| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated field in a pivot table? | Excel Worksheet Functions | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| Pivot Table - Calculated Field | Excel Discussion (Misc queries) | |||
Linear Mode
