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  

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!

ssashish786

can u provide file of it, after applying the formula data showing zero in my module.

 

 

BrunoRodriguez

Hello @ssashish786 ,

 

Are you taking this data to a module with time or without time?

Kind regards,
Bruno

ssashish786

Yes sir,
Taking time as a dimension.
In the format of line item is in number.
Is it correct can I change format of line item.

BrunoRodriguez

Hello @ssashish786 ,

 

Is this something like what you would like?

 

 

 

If that is the case that uses the same formula shown above.

 

Cheers!

ssashish786

Thank you for your answer sir.

 

I have an another query.

What r Dynamic filters  y we can use those?

 

 

BrunoRodriguez

What do you want to do?