How do I suppress a zero value or #VALUE! for a Pivot calculated i
Unfortunately IFERROR works only in XL2007. The OP probably has XL2003 or
earlier.
Your suggestion of changing "" to 0 is good, though.
Regards,
Fred
"Pritesh" wrote in message
...
Use 0 instead of "" in your forlula.
Use IFERROR instead of ISERROR.
Use IFERROR at the beginning of formula not inbetween the formula.
Try below formula;
=IFERROR(SUM(Budget)-SUM(Actual),0)
Regards,
Pritesh
"DJL" wrote:
I have entered the following formula within a new calculated item to
calculate the variance between actual and budget values with the view to
making zero values or error values a blank cell. When I insert the
formula
it removes the logic of only displaying the records relevant to the page
setting and I get the same records repeated for each page setting with
#VALUE!
Variance
=IF(OR(ISERROR(SUM(Budget)-SUM(Actual)),SUM(Budget)-SUM(Actual)=0),"",SUM(Budget)-SUM(Actual))
Thanks
|