pivot table calculated field

S

SJL

Can I use an if statement in a caclulated field formula? I'm having a
problem with spending/target returning nothing if target is null. I have
another calculated field that is spendbud/budget and want to determine the
difference between the two, but am getting null if either target or budget is
null.

Thanks in advance!
 
E

Eduardo

Hi,
The best thing is to add a column in your spreadsheet with the calculation
then include that column in your Pivot table
 
Top