3 Replies Latest reply on Feb 13, 2019 3:29 PM by Ainsley O'Sullivan

    Week-To-Date Sales

    Karolina Skvortsova

      I would like to calculate Week-to-Date Sales and I use the following formula


      IF [Day] <= TODAY()

      AND DATEDIFF('week',[Day],TODAY())= 0 THEN [Sales] END


      However according to my data I've got Sales for 22nd and 23th of January but I need the sum of sales for the period of 16-22 of January.


      How can I change the formula to get sum of sales for the correct period?