Hi all .I am having problems with getting a total sum (Aggregated Full numer) of the “Missing Profits”
I have done this the exact way Sam has done in his video and i get zero.
i have also tested this out other ways I am keep getting an absurd number

@Shrik
Since you are taking Margin Differential * Total Sales, at the grand total level the Margin Differential is 0%. So sumx is taking 0% * your total sales, which is why you are getting zero. I didnt look at how the margin differntial is being calculated, but you can add some logic that if has more than 1 value, you can take the average or median or whatever for the total level.

What would you expect to see in the Missing Profits total? If you export that data, the sum of the missing profits column is zero. If I followed this correctly (and I may be missing something since you would know this data much better) at the total level:

Total Profits: 1,494,938
Total Sales: 4,559,883
Profit Margin: 32.78%
Average Profit Margins Fixed: 32.78%
Margin Differential: 0

Missing Profits is then 0 since taking total sales * 0