Djblois
11-12-2009, 12:47 PM
I am trying to use an if Statement in Pivot Table Calculated fields but it is not doing anything. Do I need to do something special?
This is what I had:
=IF(Amt="",0,Profit/Amt)
and no matter what it always calculates the Profit/Amt portion
This is what I had:
=IF(Amt="",0,Profit/Amt)
and no matter what it always calculates the Profit/Amt portion