1 Reply Latest reply on Jul 4, 2018 11:38 PM by Deepak Rai

    Year to date calculated field (excluding current month)

    Lucas Budding

      Hi all,


      I'm trying to get a graph this year to date (2018), but excluding current month. Untill now I have:


      IF [Day] < DATETRUNC('month', TODAY())


      [Day] >= DATEADD( 'year', -1, DATETRUNC( 'year', TODAY() ) )

      then 1 else 0 END


      But it looks like he is showing more then just the numbers of this year. Can someone tell me which formula I can use?


      Thanks in advance.