2 Replies Latest reply on Jun 11, 2012 11:47 AM by Dean Lizardo

    Convert Currency on Only One (or Selected) Row(s) of Data

    Dean Lizardo

      Is there any way to show the converted value of currency on just one row of data?

       

      For example:

       

      I have 5 customers. 4 of which made purchases in US Dollars. One made a purchase in Euros. However, the data is only passed back as the value of the purchase. No conversions are made or included in my raw data.

       

      CustomerOrder Amount
      A220.00
      B100.00
      C150.00
      D75.00
      E (data is in Euros)23.00

      Is it possible to have ONLY Customer E's data converted to US Dollars? Or am I forced to simply hide/exclude Customer E and report on her separately?

       

      Ideally the raw data would already be converted for me, but that isn't currently possible. Thanks for your help!