Latest payment date

[MEC]

Hi! I have the below formula to get the latest date

LOOKUP(MAX([Payment][_RowNumber]),“Loan”,"_RowNumber",“Latest payment date”)

I don’t know if it’s working coz I can’t see the result in the app even when the “Show?” is already “ON”. Please find the below photo.

Appreciate the help in advanced!

Regards,

MEC