[_THISROW] usage? "Unable to find column '_THISROW-3' "

[Marc_Dillon]

I just wrote this expression into a virtual column:

MAXROW( Inventory Adjustment , “date” , AND( [_THISROW].[key] = [inventory] , [adjustment type] = “reset”))

It works, but first I tried to write this expression:

MAXROW( Inventory Adjustment , “date” , AND( [_THISROW] = [inventory] , [adjustment type] = “reset”))

I thought that would work. [key] column is the key column. [_THISROW] is an alias for the key column, is it not?

It throws the error:

Unable to find column ‘_THISROW-3’

Excuse me, what?