Dharris144
Board Regular
- Joined
- Jul 22, 2009
- Messages
- 97
I have a pivot table with two columns that are averages. When I insert a calculated field to subtract one from the other it looks like I am getting the sum of the differences
something like
Item target weight avg actual weight diff
abc 10.00 10.50 59.75
should be 10.00 10.50 .50
something like
Item target weight avg actual weight diff
abc 10.00 10.50 59.75
should be 10.00 10.50 .50
