Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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_purchase | Product | product_number | unitprice | Var | Index |
ene-10 | A | 1010101 | 50 | - | 100 |
feb-10 | A | 1010101 | 54 | 8% | 108 |
mar-10 | A | 1010101 | 83 | 54% | 166 |
ene-11 | A | 1010101 | 98 | 18% | 196 |
feb-11 | A | 1010101 | 55 | -44% | 110 |
mar-11 | A | 1010101 | 71 | 29% | 142 |
ene-10 | BB | 19191 | 80 | - | 100 |
feb-10 | BB | 19191 | 89 | 11% | 111 |
mar-10 | BB | 19191 | 88 | -1% | 110 |
abr-10 | BB | 19191 | 80 | -9% | 100 |
ene-11 | BB | 19191 | 85 | 6% | 106 |
feb-11 | BB | 19191 | 81 | -5% | 101 |
mar-11 | BB | 19191 | 87 | 7% | 109 |
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
It is developed in excel (see the attach)
how can we do it by QV?
some knows???
it will be really reallly helpfull....
Excellent Stefan
thanks a lot...
could you give me a extra help please?
now i need to make my resume...
i mean...
i need to evaluate last index price, avr price, first price, and last price
by year by product...
i am a begginer and if you can help would be more than great...
tahnks...
AE
Hi Angela,
see if attached file meet your requirements.
Regards!
Stefan
Stefan
Thanks toooo much.....
it was perfect !!!!!
AE