PIVOT not showing correct answer

[datastudent]

Hi,

I have a PIVOT with inserted calculated fields. The calculation is a simple IF formula. Most of the answers are correct but there are a few that are wrong and the numbers are quite far from the correct answer. I would really appreciate it if anyone can help me figure out the problem.

The formula is Partner Cost Mobile = IF(MOBILE<0.005,0.01,MOBILE+0.01)

Template_v1.xlsm
	AG		AI
1	MOBILE		Partner Cost Mobile (outbound to mobile)
12	$ 0.1724		$ 0.1824
13			$ 0.0100
14	$ 0.4180		$ 0.8061
PIVOT

 

[RoryA]

In a calculated field, all fields are summed before anything else is calculated, so your formula is actually:

= IF(SUM(MOBILE)<0.005,0.01,SUM(MOBILE)+0.01)

which is why you are seeing those results. If you want it at the row level, you either need to do that calculation in the source data or use Power Pivot and the data model.