6 Replies Latest reply: Jun 2, 2011 9:05 PM by AngelaEcheverri56 RSS

    Index Price

      How can I calculate index price of each product?

      I have in my base number_item, date_of_purchase, unit_price and supplier.

      I would like to know the firt price of purchase and the last one, to realice how the price grow betweent those dates...

      any ideas?

       

      thanks

       

      Angela E

        • Index Price

          It is developed in excel (see the attach)

          how can we do it by QV?

          some knows???

          it will be really reallly helpfull....

           

          date_of_purchaseProductproduct_numberunitpriceVarIndex
          ene-10A101010150-100
          feb-10A1010101548%                 108
          mar-10A10101018354%                 166
          ene-11A10101019818%                 196
          feb-11A101010155-44%                 110
          mar-11A10101017129%                 142
          ene-10BB1919180-100
          feb-10BB191918911%                 111
          mar-10BB1919188-1%                 110
          abr-10BB1919180-9%                 100
          ene-11BB19191856%                 106
          feb-11BB1919181-5%                 101
          mar-11BB19191877%                 109
          • Re: Index Price

            Hi Angela,

            the following script will give you the result:

             

            RawData:
            LOAD date_of_purchase, 
                 Product, 
                 product_number, 
                 unitprice,
                 if(Product = peek(Product), (unitprice - peek(unitprice))/peek(unitprice)) as Var,
                 if(Product = peek(Product), (1+Var)*peek(Index),100) as Index
            FROM IndexExample.xlsx (ooxml, embedded labels, table is Hoja1);
            

             

            Hope this helps!

            Stefan

            • Re: Index Price

              It is developed in excel (see the attach)

              how can we do it by QV?

              some knows???

              it will be really reallly helpfull....