12 Replies Latest reply on Jan 29, 2019 2:35 PM by Zhouyi Zhang

    YTD calculation starts week 2

    Barry van der Pol

      I have made a YTD calculation where [week start date] looks at the first day of the week. This calculation gave me no problems in de past. In 2019 Week 1 starts with 31-12-2018. In tableau the individual results for week one are vissible but the are not included in the YTD sales. Is it possible to make an adjustment in this calculation to get the right results including week in in my YTD results? Offcourse I can't change the sourcedata. Thanks for helping me out

       

      IF [WEEK_START_DATE] <= TODAY ()

      AND DATEDIFF('year',[WEEK_START_DATE],Today()) =0 THEN [SALES] END