Formula Problem

  • Thread starter Thread starter barbara
  • Start date Start date
B

barbara

Does anyone know why this formula will work in a
spreadsheet but not in a pivot table?

=IF(A5-B5<0,1,(A5-B5)/A5)
=IF(Spend-OtherRev<0,1,(Spend-OtherRev)/Spend)

Thanks.
 
Are you creating this as a calculated field or a calculated item?

What happens when you try to create it? Is there an error message?

Are Spend and OtherRev data fields?
 
Back
Top