I am trying to get the value of a column from the record with the most recent date. The expression I’m using is the following:
([Rego] = [_THISROW].[Rego])
It seems the MAXROW() is only considering the records that belong to the current user. Does the table’s security filter has something to do with this behavior? Is there a way to adjust the expression, so it looks at all the rows in the table?