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.
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.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |