4 Replies Latest reply on Apr 10, 2018 6:59 AM by sudheer.kumar.5

    Calculated field: sales target YTM - full current month

    Petur Mortensen



      I'm struggling to create a calculated field where it calculates the target YTM - that is: the target for the current year until the full current month. The YTD formula for the same is this:


      IF [Date] < TODAY()-1

      AND DATEDIFF('year',[Date],today()-1)=0

      AND [Date] <= DATEADD('day',-1,today()-1)

      THEN [Sales Target]



      Do you have any ideas?


      Best, Peter