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