22 Replies Latest reply: May 23, 2014 7:31 AM by Alexei Serdiuk RSS

    How to divide the quantity of store by its consumption during last three months

      Hi, everybody!

       

      Please, help me!

       

      I need to divide the quantity of store by its consumption during last three months.

       

      I'm a very beginer, so I bag your pardon for this way of expressing my idea:

       

      sum([Quantity])/(sum({<MonthName=MonthOfConsumption-1>} [Consumption]) + (sum({<MonthName=MonthOfConsumption-2>} [Consumption]) + (sum({<MonthName=MonthOfConsumption-3>} [Consumption])

       

      Thank you VERY MUCH!