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())

      and

      [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.