Highlighted
Previous Contributor

Zero needs to be shown instead of 'Infinity'

Hi, 'Infinity' has been returned as the result of MIN function as the attached screenshot. What should I do so that Zero value can be shown instead of 'Infinity'? Best regards, Maki Yasuda

1 REPLY 1
Highlighted
Contributor

Re: Zero needs to be shown instead of 'Infinity'

Hi,

In case you don't have a solution yet.
To solve this you may consider using conditonal formula and setup desired line item to be result of:
IF <YOUR FORMULA> = DIVIDE(1,0) THEN 0 ELSE <YOUR FORMULA>

DIVIDE(X,0) formula will always return Infinity as result.