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

    Latest record by date

    Yan Wu



      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.