Dear Friends,

Kindly through light for the below scenario,

Imagine that we are in June, and the average should be calculated for JAN - MAY / 5 automatically by recognizing the current month JUN. And subsequently for the following months example if we are in JULY, average should be calculated for JAN - JUNE / 6

JAN FEB MAR APR MAY JUN JULY AUG SEP OCT NOV DEC AVG
10 25 45 87 56 ?

Regards
Ramesh