cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Vrto95 Regular Visitor
Regular Visitor

elseif

Hi all,
I have two columns in my table.

first is "Curr Yr Received $" and second is "prior Yr Received $".

I need  create third column which will be count variance% ( (curr - prior) / prior).

but in this situation i should have 4 numbers (100%, -100%, 0% , someNumber%)

 

When "curr Yr" is high 0 and "prior yr" is 0,

I have some problem with "100%", how can I change my formula to replace or change "0%" with "100%"

 

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: elseif

@Vrto95 you never put that as requiement first, it is not wrong, it is working as expected, since you mentioned it, we can imrove the expression

 

Variance % =
IF( Table[CurrYr] = 0 && Table[PrevYr] = 0, 0, 
DIVIDE( Table[CurrYr] - Table[PrevYr], Table[PrevYr], 1 )
)




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




4 REPLIES 4
Super User
Super User

Re: elseif

@Vrto95 try this, change table name and column name as per your model

 

Variance % =
DIVIDE( Table[CurrYr] - Table[PrevYr], Table[PrevYr], 1 )




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




Vrto95 Regular Visitor
Regular Visitor

Re: elseif

@parry2k I tried it but when  "curr yr" and "prior yr" equals zero my "variance % " need to be equals zero too.

In your solution it equals 100% and it's wrong.

Super User
Super User

Re: elseif

@Vrto95 you never put that as requiement first, it is not wrong, it is working as expected, since you mentioned it, we can imrove the expression

 

Variance % =
IF( Table[CurrYr] = 0 && Table[PrevYr] = 0, 0, 
DIVIDE( Table[CurrYr] - Table[PrevYr], Table[PrevYr], 1 )
)




Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




Vrto95 Regular Visitor
Regular Visitor

Re: elseif

@parry2k  Thanks Smiley Happy ... it worked.