Wednesday, September 19, 2018

Display Zero Instead of Null for a Formula Field 'x/y'in a Saved Search

Instead of using the formula x/y where x is the internal id of the dividend and y is the internal id of the divisor, use the formula below.

NVL2({sales}/nullif({presentation},0), {sales}/nullif({presentation},0), 0)

This formula will return the correct quotient when the divisor is greater than 0 and will return 0 if the divisor is 0.

No comments:

Post a Comment