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.
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]
)
)
)
) )
Thanks Steveโฆ
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |