Skip to Content
0
Oct 10, 2019 at 03:13 AM

Script logic to call the values saved in different scope and combination

171 Views

Hi Experts

In the example shown below, we have two sets of source data and to calculate the logic Total Expenses multiply with Ratios with Product combinations and to post the target with product combination and country

Source Data : 1 Total EXP with the combination of some products having value ex:37000

Source Data : 2 To save the Ratio in BPC. I have taken some dummy members and saved in different scope.

Could you please help me in below logic to call the (source data 2 )[AUDIT].[RATIO] to in to logic which is saved in different scope

  • Source Data 1 (scope)
*WHEN ACCOUNT
*IS  TOTAL EXPENSE
*WHEN PRODUCT
*IS ABC
*IS DEF
*IS GHI
*REC(EXPRESSION =(source data 1) %VALUE%* (source data 2 )[AUDITIDM].[RATIO] = Target members)
*ENDWHEN
*ENDWHEN

Thanks

Kishore V

Attachments

source-data.png (19.4 kB)