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