Skip to Content
0
Jun 12, 2018 at 05:06 PM

REC using property in a ternary expression

342 Views

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