Hi
In the Module - REP01 Country Margin Report below, G3 Location and P2 Products were selected in Pages and the results are as per below screenshot.
However, in the Module - REP01 Country Margin Report - Copy below, G2 Country and P1 Product Family were selected in Pages and the results shown is '0' as per below screenshot.
Were there some steps missing? I would think that their results should be the same.
Regards
You need to check the summary methods of your line items in Source Modules.
Price Book - Summary Should be set to SUM
Volume - Summary Should be set to SUM
If either of the above is set to none it will not aggregate the values and the output will be zero.
Let us know about your findings
Misbah
The results are still different. I have tried setting Price book to None, Average and Sum. Volume always at Sum.
The results at the Copy module should be the same as the REP01 Country Margin Report but they are different even with the above Summary Settings.
@Star As Misbah suggested, you need to check if the summary of the items are set to none(in that case you will get zero).
Also, the calculation would still be wrong due to basic maths
e.g.(Volume*Price)
2*3 = 6
3*4 = 12
Now when you reference it directly, it will show the rollup value, i.e. 18. However, if we use the formula directly it will do (2+3)*(3+4) which is 35 since they are being pulled in from different modules.
Let me know if this makes sense
This is expected because you are aggregating the prices of your products as well. For example my Product Family has 3 Products i.e., P1, P2 & P3
P1 = $1
P2 = $1.5
P3 = $2.5
If you try to sum everything up, you are saying that the price of entire product family is $5 - which might not be true. Same goes to rest of the summary methods like Average etc
Keeping your summary method on Price lien item as Average will take you closer but it will not be the correct answer
In order to avoid this situation you can create a module dimensioned by Product Family and Insert one input line item and upload your prices directly instead of letting Anaplan do the aggregation.
Hope that helps
Misbah