Suppressing #VALUE! in calculated field in Pivot Tbl
 

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

Suppressing #VALUE! in calculated field in Pivot Tbl
 

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/ex...561211033.aspx
--
Pat Dools


"Pat Dools" wrote:

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