Conditional logics

[Former Member]

Hi

Can someone explain to me Conditional logic in the record statement below ?

REC(EXPRESSION=([ACCOUNT].[A_100006])>([ACCOUNT].[A_100005]) ? ([ACCOUNT].[A_100103])*([ACCOUNT].[A_100102]) : 0,ACCOUNT="A_100009")

Is it if Account A_100006 is greater than A_100005 it posted in A_100009 otherwise A_100103 is multiplied with A_100102 and posted in A_100047  ?

Thank you

Regards

Ram

[david_ings · Accepted solution]

Hi Ram,

Looks like it's always posting to A_100009 (note, you don't need the quote marks around this account).

It's currently saying:

- If A_100006 is greater than A_100005, then multiply the value of A_100103 by the value of A_100102, otherwise write a value of zero. And always write the answer to A_100009 (after removing the " ")

David

[former_member186338 · Accepted solution]

In general, REC is always posting to the single destination! Condition can be used only for the value written. If you need to write to different destinations - use multiple REC's

Writing zero is not the same as doing nothing, to do nothing - write destination over destination...

Vadim