pivot table calculated field

  • Thread starter Thread starter SJL
  • Start date Start date
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!
 
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

Combine two data sources into one pivot table 4
Problem with Calculated item in Pivot Table 1
pivot table calc item 8
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
how do I remove #DIV/0! in a pivot table calculation field ? 2
Pivot with percentages 2
Calculates field in pivot table 2
Can a pivot table calculate the difference between two fields 1

Back
Top