DATA IN MONTHS AVERAGE OF 4 MONTHS REQUIRED

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  

Tagged:

Answers

  • 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,
    Bruno

    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?

     

    BrunoRodriguez_0-1657787474955.png

     

     

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

     

    Cheers!

    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