Testing values in logic

[Former Member]

I have used logic to post values to accounts based on the account number. Now I need to post values based on account values. Logically what I want to do is this;

if account-1 value = account-2 value post account-1 value to account-3

If Excel this would be a simple formula. In script logic I am struggling to find examples that reference the account values rather than the account ids.

Thanks

Cliff

[JohnL]

You can also use GET's in a *WHEN statement to get the value as follows:

*WHEN ACCOUNT

*IS REVENUE

*WHEN GET(ACCOUNT="PRICE")

*IS 0

*REC(ACCOUNT=#PAYMENTS0,TIME=NEXT(0))

*IS 1

*REC(ACCOUNT=#PAYMENTS1,TIME=NEXT(1))

*IS 2

*REC(ACCOUNT=#PAYMENTS2,TIME=NEXT(2))

*IS 3

*REC(ACCOUNT=#PAYMENTS3,TIME=NEXT(3))

*ENDWHEN

*ENDWHEN

Thanks,

John