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