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!

[crusader_]

Hi, Alexei

What problem you faced on?

The logic of your expression is quite right, there are only syntax mistakes

sum([Quantity])/

((sum({$<MonthName={$(=MonthOfConsumption-1)}>} [Consumption]) +

     (sum({$<MonthName={$(=MonthOfConsumption-2)}>} [Consumption]) +

     (sum({$<MonthName={$(=MonthOfConsumption-3)}>} [Consumption])

)

Hope this helps.

Regards,

Andrei

[#3]

Alexei,

typpical data model for this will be something like this:

store, date, consumption

store1, 2014-01-01, 10

store1,2014-01-02, 12

store2, 2014-01-01, 34

......

In this model :

a) expression:

count(distinct store)

will give you stores number

b) expression

sum({<date={">='2014-01-01<=2014-03-31"}>}consumption)

will give you consumption from 1-01 to 31-03.

So, you final expression may be something like this:

count(distinct store)/sum({<date={">='2014-01-01<=2014-03-31"}>}consumption)

There still is the question and it deppends on you particular needs, how to get those dates for set analysis.

regards

Darek

[#4]

Андрей, спасибо за Вашу помощь!

Я попробовал вставить в диаграмму часть предложенной Вами формулы. Ожидал, что получу расход материала, сдвинутый на один месяц. А получил расход материала без сдвига.

Где я ошибся?

Еще раз спасибо!

[#5]

Dariusz, thank you!

Unfortunately, it doesn't work...

Maybe, I misunderstood you?

[#6]

Alexiej,

do you have field named: MonthName?

I think you need:

sum({<MesjacRashoda={$(=MesjacRashoda-1)}>}Raschod-kol-po)

of course pun your field names as they are in application.

regads

Darek

[#7]

Unfortunately, this metod doesn't work too...

Maybe I should try to do this in table?

Where am I mistaken?

Thank you!

[#8]

Maybe you may attach your application with sample data?

[#9]

go to staraight table and put simple $(=MiesjacRashoda) as expression. Look what result you get.

[#10]

Dariusz, I don't know why I can't succeed.

Of course I can attach the application.

And thank you very much! You're spending so much time for me!