4 Replies Latest reply: Jan 15, 2015 10:18 AM by Joseph Simmons RSS

    Calling max value in set analysis



      I have loaded in a table with Fiscal Year and RowNo() in order to be able to call the Fiscal Year value in set analysis through the max RowNo. I have done this because I was unable to call the maximum Fiscal Year (format - 'FY14').


      My formula should sum Volume for the most recent FY in the model (i.e. max row number). My set analysis is currently not working:




      Similarly, I would like to do the same for RowNo - 1, to return the 2nd most recent FY.


      The script to create the table is as follows:


      [FY Count]:

      LOAD distinct



      resident [FYCount]




      Please can you advise?