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

[Bahbus]

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.

[MEC]

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

Thanks

[LeventK]

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

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

[MEC]

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

Thanks.