Hi,
I'm trying to use an if statement as I would in Excel, but not getting anywhere. This is my formula. They are all numeric fields.
IF(([Total Amount]*[Exchange Rate])=0,[Total Amount],[Total Amount]*[Exchange Rate])
Does anyone have an idea please? I'm using classic.
Thanks
Natalie