4 Replies Latest reply on Apr 3, 2017 4:12 PM by Patrick R

    Calculated Field based on Dimension

    Patrick R

      Trying to create a calculated field for exchanges rates and running into a wall. I have a dimension field with multiple currencies. but for sepcific currency i want to multiple those values by another rate. Running into an issue when i use the below formula.


      IF CONTAINS([Currency],"USD")=TRUE then [Total Amount]*SUM([Cad Value]) ELSE [Total Amount] END


      Basically if currency says usd then multiple it by the cad fx rate otherwise give me the vanilla value.