Using Logical Function in Pivot Calculation
 

I want to perform a simple percentage calculation using two columns, but only
perform the calculation if a page field is equal to "Y". If the page field
is not "Y" I want the formula to return a blank. Where the data columns are
2005-21 and 2005-22 and the page field is 0522COV. My formula is:

=IF('0522COV'="Y",(('2005-22'-'2005-21')/'2005-21'),"")

My formula returns the #Value! error. Can logical functions be used in
Pivot calculations?

--
Thanks for your help

Mike G.