Calculated Field - Not Consistent

Jgordon

New Member
Joined
Apr 4, 2018
Messages
13
I'm having trouble as I've created this pivot table from a monthly sales table. My calculated field is sum of commission. This funny thing is the first three are correct and the last 2 are way off. Can someone point me in the direction of what to check for? I'm at a loss.

2023 Fiscal Year Progress
Row LabelsSum of BudgetSum of SalesAverage of VarianceSum of CostSum of Gross ProfitAverage of MarginBase rateSum of Commission
Jamie
$70,000​
$94,315​
34.7%​
$60,437​
$33,878​
35.9%​
0.0700​
3082.898​
Matt
$60,000​
$117,607​
96.0%​
$75,491​
$42,116​
35.8%​
0.1000​
5475.08​
Jaime
$27,159​
$16,519​
$10,640​
39.2%​
0.1000​
0​
Darcy
$60,000​
$54,463​
-9.2%​
$29,875​
$24,588​
45.1%​
0.1000​
1441259486​
Mike
$50,000​
$46,881​
-6.2%​
$27,745​
$19,136​
40.8%​
0.1000​
852609895.8​
Grand Total
$240,000​
$340,425​
41.8%​
$210,067​
$130,358​
39.4%​
0.4700​
79648.738​
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top