I have a query, that i am having data in months and count is the line 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  



  • 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!

    Kind regards,

    Bruno Rodriguez

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



  • Hello @ssashish786 ,


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

    Kind regards,

    Kind regards,

    Bruno Rodriguez

  • 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.
  • Hello @ssashish786 ,


    Is this something like what you would like?





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



    Kind regards,

    Bruno Rodriguez

  • Thank you for your answer sir.


    I have an another query.

    What r Dynamic filters  y we can use those?



  • What do you want to do?

    Kind regards,

    Bruno Rodriguez