Expression Help

[RanjanThammaiah]

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 · Accepted solution]

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?

[rajulshah]

Hello @RanjanThammaiah ,

Are you getting any error or issue?