SAC - Calculated values adding up to hierarchy nodes

Hello

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.

Thanks
Kalyan N