4 Replies Latest reply on Sep 14, 2018 12:57 PM by Tony Smith

    MTD (month to completed week)

    Tony Smith

      Hi All,

       

      Can someone please help me with the query below?

       

      I have attached a current month report to this query.  At the moment this is done manually, I need a formula that can do this for me.

       

      I only want to see the sales for the current month up to the current completed week.(starting from the 1st of each month)

       

      To determine the current BBCA completed week, I have added a calendar to the report.

       

      Using the BBCA week in fin year field the current week is 1928, however I want to see data for a complete week which is 1927 and not week 1928 which has not yet completed.  If I run the report on the 17th September 2018 when we will have completed week 1928, the current week will be 1928.

       

      Thanks

       

      Regards

      Tony