Hi

Right click on the PTTable Optionscheck Show Error values as, and either
leave as blank or set to 0 as you wish.

--
-------
Regards
Roger Govier

"DJL" wrote in message
...
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

__________ Information from ESET Smart Security, version of virus
signature database 4897 (20100226) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4897 (20100226) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4901 (20100227) __________

The message was checked by ESET Smart Security.

http://www.eset.com