Lookup another value based on the Max value of another Column

[Glaiza_Victorin]

Hi, I just want to clarify if there is something wrong with this formula?

LOOKUP(MAX(SELECT(Quote Rev List[Rev No.], [_THISROW].[Quote No.] = [Quote No.])), "Quote Rev List", "Rev No.", "Date Quoted")

LOOKUP(MAX(SELECT(Quote Rev List[Rev No.], [_THISROW].[Quote No.] = [Quote No.])), "Quote Rev List", "Rev No.", "Sub Total Amount")

LOOKUP(MAX(SELECT(Quote Rev List[Rev No.], [_THISROW].[Quote No.] = [Quote No.])), "Quote Rev List", "Rev No.", "Discount Price")

I have a Quote List Parent Table and a Quote Rev List Child Table. What I want is to get the value of the Date Quoted/Sub Total Amount/Discount Price to be reflected on the Parent Table based on the most recent revision number (Rev No.) of a particular Quote No.

But what happens is that it gets the max value of all the revision list regardless of the Quote No.

I have done this before but it was to get the most recent value based on _RowNumber. But now I want to base it on the Revision Number instead.

And I am also using this with a workflow where when a Quote Proj List (Child Table to Quote Rev List, and grandchild table to Quote List) is updated it will reflect on the Quote Rev List and Quote List.

For the Quote Rev List the sum formula is enough. But for the Quote List I am using the formulas mentioned above.

Is there any way to make this work?

I would appreciate any advice regarding this. Thank you very much.