9 Replies Latest reply on Jul 18, 2018 3:33 PM by eok

    AVG of SUMs per week in a month


      Hello everyone,

      I'm relatively new here.

      Looking for your help on how to create a formula, that will help me to get the AVG of SUMs per weeks in a given month. Sometimes it there will be 4 weeks, sometimes 5.

      Basically, I'm getting data for products A, B, C each week, I want to show AVG of SUMs per week in a given month (each month number of weeks can be different because my batch date is every Friday )

      Could you please help me with that?