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

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.
--
Regards

Roger Govier


"Tim Wheeler" wrote in message
...
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

Hi Roger

It worked - thanks for your help.

Kind regards

Tim

"Roger Govier" wrote:

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.
--
Regards

Roger Govier


"Tim Wheeler" wrote in message
...
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

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

"Tim Wheeler" wrote:

Hi Roger

It worked - thanks for your help.

Kind regards

Tim

"Roger Govier" wrote:

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.
--
Regards

Roger Govier


"Tim Wheeler" wrote in message
...
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