11 Replies Latest reply: Aug 12, 2016 10:04 AM by Sebastian Fagerlund RSS

    Pricing index

    Sebastian Fagerlund

      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..