Dear Team, I have following Tables. Operator ...

(Sarens Nass Middle East) #1

Dear Team, I have following Tables. Operator Directory - Emp Id, Operator Name, Status Operator Certification - Model Type, Certification Type Equipment Directory - Eq Code, Model Type Now If i select Eq Code with particular Model Type, Certification Type and Status, i should get list of Emp id, that will match Model Type, Certification type and Status. Can i use this formula?

ANY(SELECT(Operator Directory[Short Name], IN(Select(Operator Certification[Emp Id], AND([Certification Type] =[_THISROW].[Certification Type], [Model Type]=[_THISROW].[Model Type],

[Business Unit] = [_THISROW].[Business Unit]))))

Please advise.

(Steven Coile) #2

Your expression is bad.

It’s missing the closing parenthesis for ANY().

The IN() function is (presumably) missing its first argument.

ANY(

SELECT(

Operator Directory[Short Name],

IN(

{what you’re looking for},

SELECT(

Operator Certification[Emp Id],

AND(

[Certification Type] = [_THISROW].[Certification Type],

[Model Type] = [_THISROW].[Model Type],

[Business Unit] = [_THISROW].[Business Unit]

)

)

)

) )

(Sarens Nass Middle East) #3

Thanks Steve…