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

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

## 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.
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

## 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.