SAC Calculate after aggregation based on datasphere

[Charlielin]

Dear Expert,

   I am trying to calculate the difference of GP% between current year and last year. But the formula behave kind of weird. Here is our sample data:

We have calculated the GP% for 2024/08 and 2024/07 in the Analytic Model of Datasphere and it worked just fine(Green). But when it come to SAC story to calculate difference of 2 years, instead of simply minus one from the other, it seem to firstly calculate the difference of each SALES/COST/GP(Orange) and then calculate GP/SALES(Red) which is wrong. What we need is the calculation after aggregation which is just simply 0.42 - 0.37. 

Any suggestion?

We are using live connection from SAC to Datasphere, I've tried to create calculated measures both in the view and analytic model but neither of them worked. 

Appendix 1: Using Exception Aggregation for all fields in the Analytic Model

[Savio_Dmello]

Use SUM exception aggregation type for GP%, and specify all of the available dimensions as exception aggregation dimensions.

If that does not work, Use SUM exception aggregation type for both GP & GP%, and specify all of the available dimensions as exception aggregation dimensions.

SAP has specifically mentioned about the behavior here 

Aggregations in Formulas | SAP Help Portal

Also check this

Price * Volume Formulas | SAP Help Portal

LMK

-Savio

[Charlielin]

Thanks for your reply. Unfortunately, we are using live connection to Datasphere so exception aggregation cant be done at SAC side.