pivot table calculated field
 

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!

pivot table calculated field
 

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

"SJL" wrote:

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!