12 Replies Latest reply on Oct 25, 2016 4:44 PM by Ivan Young

    How to pull value from the most recent date?

    d Vermaak

      Hello everyone,

      I need to have some sort of calculation that pulls the "Score" from the most recent date available.

      Here is a sample of my table:

       

       

      DateScore
      1/1/201590%
      2/1/201587%
      3/1/201599%
      4/1/201567%
      5/1/201578%
      6/1/201592%
      7/1/2015

       

       

      As you can see, 7/1/2015 has no data available, so the score for 6/1/2015 should be shown.

      This is a job for TOTAL(MAX([DATE])), right? I'm not sure how to implement that though.

      Can anyone assist?