Hi everyone,
I would like to do the following calculation with 2 fields (Date and Price)
e.g. Date Price
Date | Price | Average Price | Average of Average price |
Jul-01 | 1 | | |
Aug-01 | 2 | 1.5 | |
Sep-01 | 3 | 2 | 1.75 |
Oct-01 | 4 | 2.5 | 2 |
Nov-01 | 5 | 3 | 2.25 |
Dec-01 | 6 | 3.5 | 2.5 |
Jan-02 | 7 | 4 | 2.75 |
Feb-02 | 8 | 4.5 | 3 |
Mar-02 | 9 | 5 | 3.25 |
e.g. In Nov-01,
Average price = (1+2+3+4+5)/5 = 3
Average of Average price = (1.5+2+2.5+3)/4 = 2.25
My problem is that: I want one figure 3.25 (the yellow one). How can write the formula?
That is, instead of using a pivot table for so many row, I want to get the figure of 3.25 directly.
Date | Average of Average price |
Mar-02 | 3.25 |
Any thought?
Or, it will be great if there is anyone can help to tell me:
In Script: How can I get the sum/avg/stdev of increasing time periods?
That, in Nov 01, I get the sum of price from the beginning up to Nov 01 only (Dec 01 data existing, but I don't want to include it or any data after that date)
Many thanks,
Ivan