Hi Team,
Need some quick analysis for the below data in averaging.Please suggest
Example:
I am running data for April month which should be average of above three months as shown below(Actually April data is not available...we have data till march).
| Months | Value |
| Jan | 2 |
| Feb | 3 |
| Mar | 4 |
| April | 3 |
Now when I run data for May month(which is actually not there)...it should be average of above 4 Months as shown below(April data is now made available):
| Months | Value |
| Jan | 2 |
| Feb | 3 |
| Mar | 4 |
| April | 6 |
| May | 3.75 |
Similarly when I run data for June month,it should be simply average of above 5 months as shown(May data is now made available):
| Months | Value |
| Jan | 2 |
| Feb | 3 |
| Mar | 4 |
| April | 6 |
| May | 7 |
| June | 4.4 |
Thanks in advance:)
