DATA IN MONTHS AVERAGE OF 4 MONTHS REQUIRED

ssashish786

I have a query, that i am having data in months and count is the line item.how can i average 4 months of that data.

Jan  Feb    Mar   Apr   May   Jun   Jul   Aug   Sep   Oct    Nov   Dec   FY22

120  123  140   145   150     60     70   80      86    78       79    80         ----

so Iam excepting output Average of 4 Months?

Jan Feb    Mar   Apr

?       ?      ?        ?

And what format can i take for this of lineitem?

please answer with an example and share me screen shot of that module which functions can i use for that.

 

hoping answer for the question with  

Time_in_average_142179.csv

BrunoRodriguez

Hello @ssashish786 ,

 

Would it be fair to understand that you want an average of the 4 prior months? If that is the case a formula like the following should work:

 

MOVINGSUM(Sales Value, -4, -1, AVERAGE)

 

It would be also good if you have an independent module to input the data for the -4 and the -1, making it a bit more dynamic rather than hard coded.

 

I hope I understood the question. Please let me know you asked something different!