SAC - Using dynamic time calculations in Exception Aggregation is not supported.

[Ibrahimkhalid]

Hello SAP Community,

I am getting this error, "Using dynamic time calculations in Exception Aggregation is not supported". What I want is "Mix" Total and remove its formula dependency on the last total row calculation.

"Mix" is calculating from this formula, Below is the Screenshot of the formula.

I have used Restricted Measure for "PY_Price" and "PY Parent Price".

In the screenshot below, the calculation is logically correct: the "Vol Mix Diff" in the Totals row is zero, and ("PY_Price" - "PY Parent Price") is also zero, resulting in a "Mix" value of zero. However, I want the Grand Total of "Mix" to be derived from the sum of the above rows. Additionally, I need to calculate the "Mix Contribution" in another column, which would be computed as "Mix" divided by GrandTotal("Mix"). Unfortunately, "Add Calculation" -> "Aggregation" does not support this operation. Model is analytic.

Is there any way I can achieve that ?