Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing zero value for calculated items | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |