close
I want to perform a simple percentage calculation using two columns, but only
perform the calculation if a page field is equal to quot;Yquot;. If the page field
is not quot;Yquot; 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'=quot;Yquot;,(('2005-22'-'2005-21')/'2005-21'),quot;quot;)
My formula returns the #Value! error. Can logical functions be used in
Pivot calculations?
--
Thanks for your help
Mike G.
全站熱搜
留言列表
