Suppressing #VALUE! in calculated field in Pivot Tbl

[Pat Dools]

Hello,

I am using the following formula to calculate the % of 'Current year' vs.
'Previous year', but wanting to suppress (i.e., have a blank cell) when
'Previous year' is 0:

=IF(SUM('PY GWP') = 0,"",(SUM('CY GWP')/SUM('PY GWP')))

This is a calculated field in a Pivot Table (if that makes any difference),
and would like it so that i don't get the '#VALUE!' in cells where 'PY GWP' =
0. My formula (and a number of variations on it) is not suppressing the
#VALUE! as desired. is this possible?

Thanks,

 

[Pat Dools]

Hi folks,

You might want to check this link out for an easy, global solution to what
shows and what doesn't in your Pivot Table or other Excel cells. It worked
for the problem I described below:

http://office.microsoft.com/en-us/excel/HP030561211033.aspx