3 Replies Latest reply on Jul 4, 2018 4:38 AM by Zhouyi Zhang

    Calculated Field: Division between two variables under one dimension

    shreya agarwal
      DepartmentVariable
      YearValue
      GroceryTea2011100
      GroceryConsumption (per kg)201130

       

      I want to calculate Consumption per Tea stock (Consumption/Tea). How should I perform this division in the calculated field?

       

      I tried this: (Variable = "Consumption(per kg)")/(Variable = "Tea")

       

      But, that's division between two string values. How should I get values in the equation?