4 Replies Latest reply on Dec 2, 2016 8:49 AM by David Li

    How to make a Count of Weeks in a period include missing weeks

    Karen Green

      I have been searching in the forums for a while but can't find the answer I need.  I have a text table showing weekly sales results by category by year.  For example, in 2013, I have 51 weeks for one category and 49 weeks for another category instead of 52 weeks for both categories. So obviously it isn't counting the weeks where there were no sales in the category.  Here is the calculated field I used to get the count of weeks.  Is there something I can add so it will count the weeks where they were no sales?  You can see that the Count of Weeks is not consistent.

       

      COUNTD([Approval Date (Week numbers)])

       

       

      Thanks,