We have a scenario where we are calculating "Amount Per Case" via data action.
Amount Per Case = Amount / Volume
The values marked in green against Child member are calculated as expected which are at month level.
i.e. GL = Child and Date = Jan, Feb, Mar
But when it comes to Quarters & Year level (marked in yellow), calculation is not happening and the values are being added up to hierarchy nodes.
i.e. GL = Parent and Date = 2024, 2024.Q1 etc
We cannot use calculated measures because we need to use the measure value for further calculations in data actions.
Data action code:
MEMBERSET [d/Date] = [d/Version].[p/STARTDATE] TO [d/Version].[p/ENDDATE]
MEMBERSET [d/GLACCOUNT] = BASEMEMBER([d/GLACCOUNT] , "PARENT")
DATA([d/Measures] = "AMOUNTPERCASE") = RESULTLOOKUP([d/Measures]="AMOUNT") / RESULTLOOKUP([d/Measures]="VOLUME")
Can someone pls let me know how to fix this issue.