Suppressing #VALUE! in calculated field in Pivot Tbl


Pat Dools


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?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question