Hi,

I have the following nested IF custom formula in one of my table columns. It gives me the results I want. However, it does not run on newly imported records. Can you please tell me why? 

IF("CURRENCY"='EURO',"(+) AMOUNT INCOME"*2.3,IF("CURRENCY"='USD',"(+) AMOUNT INCOME"*1.8,"(+) AMOUNT INCOME"))

The intended meaning of the formula is: 

Dear table, please look in your currency column, if you see Euro than multiply the amount for 2.3. On the other hand, if you see USD multiply for 1.8. Finally, if you find anything else put the amount without multiplying..