5 Replies Latest reply: Jan 22, 2018 1:37 AM by Mohammad Adnan Ansari RSS

    Avg Sales per day - based on different days of work

    Mohammad Adnan Ansari

      I am working on Retail Sales data.

       

      In some cities the stores works 7 days whereas in some they work 6 days a week.

       

      So when I do an average sales per day for a month calculation it should take into account the operational days to calculate.  Let say for the month of January 2018; for Cities where the stores are closed on Sunday, the number of days is 27 whereas for other cities the number of days is 31.

       

      I am using standard master calendar.

       

      The below are the table formats:

       

      Store:

      Store

      Store City

       

      City Operational Days:

      City

      Operational Day. (Sat, Sun, Mon etc)

       

      Sales:

      Invoice No

      Item

      Store

      Qty

      Sales

       

      I need the average Sales Per day