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

Calculated Field: Division between two variables under one dimension

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?

• 1. Re: Calculated Field: Division between two variables under one dimension

HI Shreya,

Is it possible to restructure your data like this? -

Because this way, you can just do sum(Consumption)/Sum(Tea)

Thanks,

Mavis

• 2. Re: Calculated Field: Division between two variables under one dimension

Hi Shreya,

Please find my approach as referenced below.

Create calculated fields

Let me know if that helps or not.

~Tushar

1 of 1 people found this helpful
• 3. Re: Calculated Field: Division between two variables under one dimension

Hi, Shreya

Please find my solution attached as well as below screenshot for reference.

Hope this helps

ZZ

1 of 1 people found this helpful