0 Replies Latest reply on Oct 28, 2013 12:26 PM by Yan Wu

    Latest record by date

    Yan Wu

      Hello,

       

      Please refer to sheet 5.

       

      In the attached file, I have a column for date titled AS_OF_DATE.

       

      In the measures, there's an average and a standard deviation of the field "OPEN INV"

       

      I would also like to create a field that displays the most recent OPEN INV by AS_OF_DATE.

       

      How do I create a formula that would make this work?  Thank you.