cancel
Showing results for
Did you mean:
Highlighted
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%"

1 ACCEPTED SOLUTION

Accepted Solutions
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 )
)```

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

4 REPLIES 4
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 )```

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

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

## 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 )
)```

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

Regular Visitor

## Re: elseif

@parry2k  Thanks ... it worked.