Formula tool

[Elena_B1]

Hello. I'm trying to  to categorize transactions based on their Document Type, Offsetting account number, Text, and currency amounts. Could you please help to correct the formula below.

IF [Document Type]="AC" OR [Document Type]="AR" THEN "Accrual/Accrual Reversal"

ELSEIF [Offsetting acct no.]=[Offsetting acct no.] AND [Text] = [Text] And [Amount in local currency] oposit [Amount in doc. curr.] THEN "Reclass"

ELSE "Other"

ENDIF

[alexnajm]

@Elena_B1 what is "oposit"? Is it an inverse function? Also it looks like these are unnecessary as they are just saying each column equals itself: [Offsetting acct no.]=[Offsetting acct no.] AND [Text] = [Text]

Based on my assumptions:

IF [Document Type]="AC" OR [Document Type]="AR" THEN "Accrual/Accrual Reversal"

ELSEIF [Amount in local currency] = -1*[Amount in doc. curr.] THEN "Reclass"

ELSE "Other"

ENDIF

[Elena_B1]

Unfortunately, it is not working for me. the highlighted should be categorized as "reclass". Could you please help?

[Dina]

I think you are referring a wrong column. [amount] will never equal to -1*[amount] , since it is same column. Based on your note, seems like it should be [Amount in local currency] = -1*[Amount in doc. curr.] . Or you can put [amount]<0 to check if amount is a negative number.