0 Replies Latest reply: Mar 8, 2013 4:56 AM by Alan Hendrickx RSS

    Expression - returning the desired field

    Alan Hendrickx

      Hi,

       

      The below expression returns an Audit Update ID record.

       

      aggr(num(max([Audit Update ID],2)),[Update ID],[Action Item ID])

       

      I would like to use the above expression to get the correct Audit Update ID (which it does), and then use this to return another field value (% complete).

      Any help in how I structure this would be greatly appreciated.

       

      Thanks,

      Alan