6 Replies Latest reply on Jul 24, 2018 2:05 PM by Tony Smith

    Formula for year to date.

    Tony Smith

      Hi All,

       

      Can someone please help.

       

      I want the report to give me year to date sales.  At the moment, I have manually filtered the BBCA Year and BBCA Week in fin year.  I want to a formula to do this.  The BBCA FISCAL year starts on the 1st of March.

       

      I used the Report Date field to recognise the current BBCA week in fin year.

       

      For example, today is 24th July 2018, so the current BBCA week in fin year is 1920 because we now have a completed week according to the BBCA week in fin year date.

       

      I have attached twbx package that shows the details of the BBCA week in fin year date

       

      Thanks

       

      Regards

      Tony