on 2022 Feb 08 12:07 PM
Hi Team,
We have a scenario where user inputs forecasted Revenue and Cost let say in Accounts F_REV and F_COST respectively.
Now based on conditions we need to execute different section of scripts as explained below.
Condition 1: If F_REV>0 and F_COST>0 then execute one section of the script logic where the costs are calculated as (Driver cost/ driver revenue)* forecasted revenue
Condition 2: Else we will simply allocate the forecasted cost into the various cost accounts based on their share(Run allocation logic)
F_REV and F_COST are stored against INPUT data source and the calculated costs are stored against CALC data sources.
Can one please suggest how to achieve this using script logic? We are using BPC 11.1NW standard version on BW4HANA.
Regards
Pragyana
Request clarification before answering.
You can check for condition for value in WHEN/ENDWHEN REC statement:
*REC(EXPRESSION=%VALUE%>0 ? ... : ...
You can use nested ... ? ... : ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.