Dear Experts,
I get a syntax problem and I don't know how to write the correct syntax for one expression on our BPC 10.1 (SP10).
The purpose is that we get values on a FLOW (Correction) and we want to add the value of this one to another flow using a property in our ACCOUNT dimension (Pos_Flow if the value is positive and Neg_Flow if the value is negative).
I try writing the formula with some syntax like :
*REC(EXPRESSION = %VALUE% > 0 ? %VALUE% + [FLOW].([ACCOUNT].properties.POS_FLOW) : 0 , FLOW=ACCOUNT.POS_FLOW)
*REC(EXPRESSION = %VALUE% > 0 ? %VALUE% + [FLOW].[ACCOUNT].[POS_FLOW] : 0 , FLOW=ACCOUNT.POS_FLOW)
And I try using a SELECT statement with the same issue (RUN_LOGIC: syntax error: " missing name after . operator")
When I only try to write data on the property it works properly like you see below :
*REC(EXPRESSION = %VALUE% , FLOW=ACCOUNT.POS_FLOW)
but I can't find the good syntax to perform the ternary expression.
Could you help me ?
Many thanks for your help.
Stéphane