2 Replies Latest reply on May 9, 2013 7:54 AM by Ryan Johnson

    How to perform multiple currency conversions to USD

    Ryan Johnson

      In my table I've got a field called [PROJECT_TOTAL] and a field called [PROJECT_CURRENCY].  I've got GBPs, EURs and USDs in [PROJECT_CURRENCY], but I need to display them all as USDs.  I'm assuming I need to do some sort of logical expression(s) in a calculated field.  I tried writing multiple statements and combining them into one.  Something like:

       

      Calc 1 - IF PROJECT_CURRENCY = 'GBP' THEN ([PROJECT_TOTAL]/.65) ELSE 0 END

      Calc 2 - IF PROJECT_CURRENCY = 'EUR' THEN ([PROJECT_TOTAL]/.75) ELSE 0 END

       

      But then I wasn't sure where to proceed from there.  Any ideas?