on 2022 Jul 08 4:27 PM
Hello experts,
I'm trying to find a way to use the expression EXPRESSION = ( (A>B) ? C : D, value = E), but with multiple conditions instead of one ? Is it a knowing code ?
Basic Exemple. Conditions :
If A>B & D>C than E
If A<B & D<C than F
else : Nothing
Also, do you know how to do post "nothing" using this condition ? Meaning if condition 1 = true than Account = E, if condition 2 = true than Account = F else nothing.
Thanks a lot in advance experts !
Camille
Request clarification before answering.
Multiple conditions can be created using:
&& - AND
|| - OR
To post nothing you can post target tuple
*REC(EXPRESSION=(%VALUE%>0 && [ACCOUNT].[ACCT1]<1000) ? %VALUE% : [ACCOUNT].[ACCT2], ACCOUNT=ACCT2)
Also, posting 0 can be fine for nothing
*REC(EXPRESSION=(%VALUE%>0 && [ACCOUNT].[ACCT1]<1000) ? %VALUE% : 0, ACCOUNT=ACCT2)
*REC(EXPRESSION=(%VALUE%<0 && [ACCOUNT].[ACCT1]>1000) ? %VALUE% : 0, ACCOUNT=ACCT2)
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.