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

    Calling max value in set analysis

      Hello,

       

      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:

       

      =sum({$<[FiscalYear2]={$(=max(RowNo()))}>}[Volume])

       

      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

      FiscalYear2,

      RowNo()

      resident [FYCount]

      ;

       

       

      Please can you advise?

       

      Thanks,

      M