Suppressing zero value for calculated items
 

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

Suppressing zero value for calculated items
 

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

Suppressing zero value for calculated items
 

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

Suppressing zero value for calculated items
 

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