2 Replies Latest reply on Jul 31, 2018 2:42 PM by Mavis Liu

    Formula for this current quarter and last year same quarter

    Tony Smith

      Hi All,

       

      Can someone please help me with the query below?

       

      I have attached a current quarter 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 quarter up to the current completed week.

       

      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 1922, however I want to see data for a complete week which is 1921 and not week 1922 which has not yet completed.  If I run the report on the 5th August 2018 when we will have completed week 1922, the current week will be 1922.

       

      Thanks

       

      Regards

      Tony