Solved: Expression Help

RanjanThammaiah · ‎12-12-2019

Hi All,

Can any one help me to get the below expression get corrected.

Not sure for some reason its not working.

i need to create a slicer with. Exceeding Plan,On Track, behind Plan. based on the Variance to Plan % measure.

Performance Vs Plan = IFERROR(IF([Var to Plan%]>=0.5,"Exceeding Plan",IF([Var to Plan%]>= 0,"On Track", "Behind Plan")),0)

Exceeding Plan	>=5%
On Track	0-5%
behind Plan. based	>0

Regards,

Ranjan

v-diye-msft · ‎12-15-2019

Hi @RanjanThammaiah

Try this:

Performance Vs Plan = IFERROR(IF([Var to Plan%]>=0.05,"Exceeding Plan",IF([Var to Plan%]>= 0,"On Track", "Behind Plan")),0)

5%=0.05 rather than 0.5, isn't it?

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

v-diye-msft · ‎12-15-2019

Hi @RanjanThammaiah

Try this:

Performance Vs Plan = IFERROR(IF([Var to Plan%]>=0.05,"Exceeding Plan",IF([Var to Plan%]>= 0,"On Track", "Behind Plan")),0)

5%=0.05 rather than 0.5, isn't it?

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.