Using the Parent data in Scriptlogic calculation

40 Views Last edit Feb 10, 2020 at 07:13 PM 2 rev

Hi,

We are on SAPKW73105,SAPK-80104INCPMBPC.

I would like to use a parent (Account dimension)member in script logic calculation.

Renewal rate is a parent member and has 7 child members.
Formula for calculation:
CHURN=1-RENEWAL

Script Logic:

*WHEN ACCOUNT
*IS RENEWAL
*REC(EXPRESSION =((1- %VALUE%),ACCOUNT = CHURN,AUDITTRAIL = CALC)
*ENDWHEN

But the calcualation is not returning any value for CHURN.

Please help me to get the parent member value in calculation.

Thanks