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

      Hello

       

      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]

      END

       

      Do you have any ideas?

       

      Best, Peter