How to use MAXROW with Related List instead of the Table ?

[Manish_Jain11]

How to get MAXROW from Related List instead of the Table ? 
I tried this but doesn’t work

Maxrow([Related Dies], “_rownumber”)

[Steve · Accepted solution]

You can't use MAXROW() for that. This should be equivalent:

ANY(
  ORDERBY(
    [Related Dies],
    [_ROWNUMBER],
      true
  )
)

[Hani_Ibrahim]

Can we use time stamp instead of row number?

[Steve]

Yes, you can use a time stamp instead of the row number.

[Manish_Jain11]

Thanks Steve but this will choose a random value instead of the one with maximum row number. I want the row with maximum row number (the latest one) .

[Steve]

Wrong.

[Hani_Ibrahim]

@Steve I am using the following expression to arrange a different table in order to fetch the last value. unfortunately,  it says (ORDERBY has invalid inputs). Am i writing it wrong?

ANY(
		ORDERBY(
    		Submittal RevNo[Rev],
        Submittal RevNo[_RowNumber],
        TRUE
    )

)

[Steve]

ANY(
  ORDERBY(
    Submittal RevNo[Rev],
    [_RowNumber],
      TRUE
  )
)

[Hani_Ibrahim]

Still giving (ORDERBY has invalid inputs)😞

[Steve]

https://help.appsheet.com/en/articles/2357312-orderby

[Hani_Ibrahim]

Thank you. It is comprehensive 🙏