Zero needs to be shown instead of 'Infinity'

PrevContributor

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

?.Szyma_ski

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.