6 Replies Latest reply on Nov 15, 2013 6:02 AM by Victor Blaer

    Calculated Field and where statement (Fx conversion)

    Victor Blaer

      Hi everyone,

      I have two dimensions [SETTLE_CURRENCY] and [TRAN_CURRENCY] and a measure [PURCHASE_SENT].

      I´d like to convert the [TRAN_CURRENCY] (aud, jpy etc) into EUR but I´m unsure how to do it .

      Please see the excel sheet for data and what I'm trying to achieve, many thanks!