If Statement help with formula function

Question

Hello,

We are hoping to create a currency column for the output based on if a number is located in the "Recoverable Total CAD" or "Recoverable Total USD" column. For any amounts in the "Recoverable Total CAD" we want CAD to be displayed in the currency code column and USD for "Recoverable Total USD". Currently we have two formulas set up for this column but one formula appears to be overriding the other. The currency column chart is displaying all zeros except for the amounts that are "Recoverable Total USD". Please let us know how to fix this issue.

Thank you

Capture.PNG

philipmannering · Accepted Answer

Just ammending the above slightly to take care of the rogue quotation mark and allocating a number to a string field,

if [Recoverable Total CAD] then "CAD" 
elseif [Recoverable Total USD] then "USD" 
else Null() endif

I believe this will be "CAD" for any non-zero value of [Recoverable Total CAD], and only then be "USD for any non-zero values of [Recoverable Total USD]. Null if both are zero.