Latest payment date

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

Generally the column hides itself if the column contains a blank value and offers no input. So more than likely there is something wrong with your expression.

1 Like

Thank you. How do I troubleshoot the error then? Do you have any idea?

Thanks

@MEC
Is Payment column a REF_ROWS column in your table? If not, try with this:

LOOKUP(
    [_THISROW].[_RowNumber],
    "Loan",
    "_RowNumber",
    "Latest payment date"
)

@LeventK Yes it is a REF_ROWS. I have found a solution. I just have entered the formula in google sheet.

Thanks.