Formula Problem

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.
 
D

Debra Dalgleish

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
formula question 2
yearfrac format error? 4
Sum and multiply at the same time? 5
INDIRECT formula not working 1
Formula Content linked to other cells formula Content 5
Average of Days Between Customers Visits 0
Weighted Average 7

Top