Formula indicator 0 as 100%

[jules2]

HI

I have created a formula indicator that calculates a percentage in a value based on 2 automated indicators.

The formula works fine when incidents come in.

However on occasion when no tickets come in. The values for both indicators are zero resulting in a   zero percentage value.

Is there a way you can add an exception rule to a formula to make the percentage value 100% when no tickets come in?

[Naresh27]

when both numerator and denominator were zero, your formula indicator should through undefined meaning blank but not zero.

however if you would like to show 100%. this is the syntax.

{{DenominatoreratorIndicator}}= 0 ? 100 : {{NumeratoreratorIndicator}}/{{DenominatoreratorIndicator}}

let me know if this does not work

[Arnoud Kooi · Accepted solution]

To compare, you need   [[DenominatoreratorIndicator]] == 0