Zero needs to be shown instead of 'Infinity'

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

Message 1 of 2
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.

Message 2 of 2