12 Replies Latest reply: Dec 9, 2013 9:25 AM by Mark campbell RSS

    Set Analysis max date

      I am trying to return a value where date=max(date); however, I can't seem to get the function designed quite right.  I have tried multiple options, I'll list a few below that didn't seem to work:

       

      only({<$DATE={$(=max($DATE))}>} MTD) :: returns nulls

      sum({<$DATE={$(=max($DATE))}>} MTD) :: returns 10.5 for acct A

       

       

      fact:

      load * inline [

      acct,date,mtd

      A,1-1-2013,3.4

      A,1-2-2013,3.5

      A,1-3-2013,3.6

      B,1-1-2013,3.2

      B,1-2-2013,2.8

      ]

       

      chart:

      dim=acct:

      acct     | mtd where date=max(date)

      A          | 3.6

      B          | 2.8