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

    YTD & QTD Expression with an alternate start of year?

    Steve Fewster

      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.


      1.png
       

       

       

      Any ideas?

       

      Thanks

       

      Steve