3 Replies Latest reply on Nov 19, 2018 6:31 AM by Andrew Horiates

    I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)

    Andrew Horiates

      I want to show the latest score. I feel like this should be easy, but I cannot figure it out. I can get it to show me the last date, just not the Score. The max score by floor should be a 1-3.

       

      I am using this for the last date: { FIXED [Facility],[Type of Exercise],[Building Floor]: MAX(DATE([Date of Exercise]))}

       

      I have attached a workbook. please help.