Suppressing zero value for calculated items

[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

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

Roger Govier


"Tim Wheeler" <TimWheeler@discussions.microsoft.com> wrote in message
news:38322CB2-68C2-4038-9486-D3CD76023AC3@microsoft.com...
> 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

[Tim Wheeler]

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" <TimWheeler@discussions.microsoft.com> wrote in message
> news:38322CB2-68C2-4038-9486-D3CD76023AC3@microsoft.com...
> > 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
>
>
>