Calculated field in Pivot

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
I have the below data (sorry I can't convert to html, it says "Error:1004")

Region__ Model__ Revenue
North__ A__ 10
West__ B__ 11
South__ C__ 12
South__ D__ 13
South__ A__ 14
East__ A__ 15
East__ B__ 16

And I created a pivot that looks like this (this one can be coverted to html):
Book2
ABCD
1Data
2ModelSumofRevenueSumofCost
3A390
4B270
5C120
6D130
7GrandTotal910
Sheet2


The "Cost" field is a calculated field, with the follwing formula:

Code:
= IF(Model ="A",Revenue *0.8,IF(Model ="B",Revenue *0.7,IF(Model ="C",Revenue *0.6,IF(Model ="D",Revenue *0.5))))

So, can somebody tell me why is it returning zero values?

Thanks
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,916
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top