Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
Hi Sunny,
you've got time to check this?