Zero needs to be shown instead of 'Infinity'
Options
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
Tagged:
0
Answers

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