Pricing index

[sebastian_fager]

Hi,

I want to calculate a pricing index.

First i need the latest average price per week per product.

To do that i use this formula:

sum({<YearWeek={$(=max(YearWeek))}>}Sales)

/

sum({<YearWeek={$(=max(YearWeek))}>}Quantity)

The problem is the value in the tabell only shows when i mark a product, why?

And later, I would divide the value above with a stuck zero/starting point to get a index.

How should i do that?

sum({<YearWeek={$(=min(YearWeek))}>}Sales)?

But then i don't know the start week, because it's different between the products..

[sunny_talwar]

Hahahahaha sorry my bad, I have been delusional reading both INVOICE_AMOUNT and INVOICE_QUANTITY as the same thing. I will look at this now again with open mind

[sebastian_fager]

Hi Sunny,

you've got time to check this?