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
      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?