cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emillio Frequent Visitor
Frequent Visitor

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. 

 

Is there a way to format any numbers above or below 100 to show for instance as 100+ or 100- ? The formula I'm using is: 

 

∆ % = DIVIDE('KPI budget tabel'[Werkelijk]-'KPI budget tabel'[FC 1];'KPI budget tabel'[FC 1])

 

Thanks ! 

emillio. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: format results above 100 with divide function

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

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

Re: format results above 100 with divide function

Hi @emillio,

 

You can try this formula.

∆ % = IF(DIVIDE('KPI budget tabel'[Werkelijk]-'KPI budget tabel'[FC 1],'KPI budget tabel'[FC 1])>1,"100+","100-")

 

But you should be aware that the displayed values "100+", "100-" are text type, instead of numeric.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
emillio Frequent Visitor
Frequent Visitor

Re: format results above 100 with divide function

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
Community Support Team
Community Support Team

Re: format results above 100 with divide function

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

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