Suppressing zero value for calculated items

T

Tim Wheeler

Hi, has anyone figured out how to suppress zero results for calculated items
in a pivot? I have tried to use an "IF zero then NULL" formula but this does
not work - I assume item calculations do not allow the use of standard Excel
function?

Thanks

Tim
 
R

Roger Govier

Hi Tim

You can enter standard Excel formulae to any calculated field in a PT.
For example
=IF(SUM('Actual')-SUM('Budget
Number')=0,"",SUM('Actual')-SUM('Budget Number'))

where the items within the single quotes are your field names from the
PT.
 
A

AA

This doesn't work for a calculated ITEM - it does for a calculated field.
Any other ideas for calculated ITEMS? with this type of formula I'm getting
a #VALUE returned

thanks
 
Top