Forum Discussion
Solved
format results above 100 with divide function
HI All, I'm using a Divide function to calculate the difference between my results and the budget. However, in some cases, my results appear above 100%. Even going up to 1000% above budget. ...
Hi emillio,
You can try this:
∆ % = IF(DIVIDE('KPI budget tabel'[Werkelijk]-'KPI budget tabel'[FC 1],'KPI budget tabel'[FC 1])>1,100,-100)
Regards,
Yuliana Gu
Thanks for that Yuliana,
That will be a problem indeed, since the rest of my values will be percentages. Any chance I can just let it return 100 or -100 ? That will do the trick as well I guess.
Regards,
Emillio
That will be a problem indeed, since the rest of my values will be percentages. Any chance I can just let it return 100 or -100 ? That will do the trick as well I guess.
Regards,
Emillio
Hi emillio,
You can try this:
∆ % = IF(DIVIDE('KPI budget tabel'[Werkelijk]-'KPI budget tabel'[FC 1],'KPI budget tabel'[FC 1])>1,100,-100)
Regards,
Yuliana Gu