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

[#1]

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!

[#2]

Андрей, большое спасибо!

Буду учиться дальше.

[SergeyMak]

Hi Alexei,

It doesn't work because you have date in format like "31.03.2013" and in your last expression you are trying to compare it with "2013-01-01. Thus it doesn't work.

PFA

[#4]

Sergey, thank you very much!