Skip to Content
0
Former Member
Nov 02, 2010 at 05:51 PM

IF formula in internal column of conversion file

64 Views

Dear experts,

I have some problems with a conversion file.

I have an external account which depending its amount it should be loaded in one internal account or in another internal account.

Example:

If the amount is <0 it should be loaded in account X

If the amount is >= 0 it should be loaded in account Y

Do you know if there is a formula that allows to do this?

I tried the following in the internal column:

If(%value%<0, X; Y)

But it fails the validation of the conversion file.

Any suggestion please?

Thanks in advance.