We have a plan element called "Adjusted total" which has a formula as below.
"OFS_Direct Input" + ("OFS_Direct Input" * "OFS_% Increase/(Decrease)");
which is working as expected.
But for aggregation for sparse dimension at parent level, it is not taking the aggregation, but rather still takes the formula even at the aggregation level.
Is there a way we can get row no 20 in the attached sheet to take the aggregation and not the formula value?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):