Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am having numbers need to be added as cumilatively. Range sum() will do that. After that i need to get average of those numbers monthly. I am having 5 years of data.
For example
In this case if i want to calculate Avg for May-17 i need to consider (72+102)/2 insted of (12+30)/2
monthyear | Value | Range sum |
Jan-17 | 15 | 15 |
Feb-17 | 20 | 35 |
Mar-17 | 25 | 60 |
Apr-17 | 12 | 72 |
May-17 | 30 | 102 |
How can i achieve this. Thanks in advance.
Regards,
Sadasiva
Hi Sada,
Please Close this Thread.
Thanks,
Arvind Patil
Done