3 Replies Latest reply on Feb 6, 2013 3:51 PM by Dimitri.B

    Rolling date calculations

    Kevin Hogan

      Hey Guys,


      I have been working with some survey data and the next step is getting it to Rolling 3, R6, and R12 M calculations.  Ideally I want it set up as a trendline going from month to month with a percentage of yes answers Rolling X months back.  I can get the Rolling X calculation using this formula:


      IF  DATEDIFF('month', [Month Of Interview], now())< X+1 then [Respondent Number] END


      I do a COUNTD on that and get the number of answers for a certain question for the last X months which is great but I'm not sure how to get a reference date in for the now().  I can attach a book if necessary.