Formula Help

[ai1094]

Hi, I have a Pivot Table with a basic calculated field in them.

It is just taking two numbers from different columns and dividing them. However, there are instances where both the columns have a zero value and returns the #DIV/0! value. Is there anyway I can write the formula in the calculated field so that if the value returns #DIV/0! it will just equal 0 (zero)?

 

[Jon von der Heyden]

IF(Denominator,Numerator/Denominator,0)

I believe you can use an IF statement such as the above ^

 

[ai1094]

I figured it out. Thanks!