1 Reply Latest reply on May 10, 2017 2:17 PM by Patrick A Van Der Hyde

    YTD formulas with growth over previous period

    Alex Martino

      I'm using this formula to get YTD. And a similar formula to get prior YTD. But when I click a quick table calc on the current YTD it erases prior YTD but doesn't show me the % growth, and there is no change to the numbers. Any thoughts?

       

      IF

      YEAR([Date]) = YEAR([First Satisfied Date])

      and

      [First Satisfied Date] <= [Date]

      then

      [Contract ID]

      END