I’m trying to get an automated fill based on my table called database that has collumns called [class][type][classification][Height][wide][length]. The thing is, I try to autofill the [class] collumn based on [type],[height] and [wide]. for example if the [type] value is square than it will look into the [height] dan [wide] collumn, if the value of those collumn is 4 it will autofill the [class] collumn with A1 etc.
I have use this expression ANY( SELECT(Database[class], AND( ([Height] = Database[Height]), ([Wide] = database[wide]), ([type] = [_ThisRow].database[type])), FALSE ) ). But it returns with error message "Cannot compare Number with List in ([height] = DATABASE[height]).
hope you understand my question