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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Calculated item in Pivot Table 1
Combine two data sources into one pivot table 4
pivot table calc item 8
Pivot with percentages 2
how do I remove #DIV/0! in a pivot table calculation field ? 2
Calculations in Pivot Tables 6
Calculates field in pivot table 2
Can a pivot table calculate the difference between two fields 1

Top