SCRIPT Logic using Parent Value

[former_member640296]

We are having ACCOUNT dimension having

ACC_A

ACC_B,

We also have DEPT dimension where

DEPALL is parent of

DEPA,

DEPB,

DEPC

We want to use value of ACC_A for each base member of DEPT dimension and divide it by value of ACC_A of DEPALL and store the result into ACC_B

*XDIM_MEMBERSET ACCOUNT= ACC_A, ACC_B

*XDIM_MEMBERSET DEPT=BAS(DEPALL)

*WHEN ACCOUNT

*IS ACC_A

*WHEN DEPT

*IS %DPT%

*REC(S_ACCOUNT=ACC_B,EXPRESSION=( %VALUE% / %DPT%.PARENT ))

*ENDWHEN

*ENDWHEN

However not able to get the required result. What we need is ACC_A Value at base level of DEP divided by ACC_A Value at Parent of that DEP and store it into ACC_B.

[former_member640296]

As shown above, need department wise %tage. Hence need to get dynamically total of parent of respective dep to calculate the %tage as shown in above.

[former_member186338]

Still not clear! Do you want to perform calculations for all departments??

P.S. Can you provide your BPC version and SP?