5 Replies Latest reply: Nov 24, 2013 3:19 PM by Steve Fewster RSS

    YTD & QTD Expression with an alternate start of year?

      Hi All,


      I'm trying to get the max value within a period (YTD & QTD) for a field, where I have a moving start of year defined by a user input so it will not be the 1st of Jan. I don't appear to be getting expected values with my command below


      =max(if(InYearToDate(DateRecorded,today(1),0,0),Reading)) retrieves the right ytd values assuming a Jan start of year.

      =max(if(InYearToDate(DateRecorded,today(1),0,7),Reading)) I've tried putting first month of year as 7 for July so that I should a different value in my table, but I'm getting the same value as the expression above.




      Any ideas?