5 Replies Latest reply on Oct 25, 2018 7:41 AM by Ombir Rathee

    MAX of one field based on another?

    Michael Chambers

      I've attached a workbook. I'm really not sure what is needed here, whether it's an LOD calc or if it's easier than that.

       

      I have a parameter called Select Date, and the Calculated Field I'm trying to figure out is Current Category. At all times, I want the Current Category field to be identical for each Project ID, and I want that to equal the most recent Category. So I want the MAX of Category, but based on the date, not the MAX of Category by alphabetical.

       

      If I choose 4/17/18, I want ID 353 to show 20-Blue for each record, and ID 400 to show 20-Blue.

       

      If I choose 7/20/18, I want ID 353 to show 10-Red for each record, and ID 400 to show 20-Blue.

       

      Please let me know if this needs any further clarification.

       

      Thanks!