1 Reply Latest reply on Jan 24, 2017 12:40 AM by Karolina Skvortsova

    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?