The script will be (using conditional ternary operator):
*XDIM_MEMBERSET Account=Account1,Account2 //listof required accounts *XDIM_MEMBERSET Category=Version1 //Category with signed data *WHEN Account *IS * *REC(EXPRESSION=%VALUE%==10 ? [Category].[Version2]*2 : [Category].[Version2],Category=Version2) //save result in Version2 *ENDWHEN
Sorry, but the requirements are not clear!
Please provide info in line with https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/
Sorry, but logic is still not clear:
"the calculation would be If a certain department has signed data as 10 in Version1 record 1000*2 Euros in Version2"
and
"Calculation Logic: Account= Account*2"
10*2=20 ???
Also I do not understand what's the issue?
*XDIM_MEMBERSET Account=Account1,Account2 //list of required accounts *XDIM_MEMBERSET Category=Version1 //Category with signed data *WHEN Account *IS * *REC(EXPRESSION=%VALUE%*2,Category=Version2) //save result in Version2 *ENDWHEN
Add comment