Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Андрей, большое спасибо!
Буду учиться дальше.
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
Sergey, thank you very much!