FCC Data Management Complex Logic Account

Content

I am trying to create a logic account in FCC Data Management

Complex Logic Account to aggregate a series of accounts I.E. 1001,1002,1003 and if the sum of these 3 accounts is a positive post to CA150043 and if Negative post to CL200031, however when I select the Calc option on the logic account it does not aggregate the accounts into 1 line it creates a line for each account and maps to the target account based on the individual account sign not the sum.

Has anyone got this working in FCC and can help me please?

Thanks in advance

Sarah