I’m working on a Inspection survey app.
What I’m looking for is a notification (workflow) that checks if the amounts of defects for an
specific Employee, for today and for an specific group is Greater that X number that comes from an other table, if so… advice me!!
This is my formula:
AND( SUM( SELECT( Inspection Detail[# Defects], AND( [Employee] = [_THISROW].[Emplyee], [Date] = TODAY(), [Group]="Group #10" ) ) ) > ANY( SELECT( Alerts[Maximun Amount of defects], [Defect]=[_THISROW].[Defect] ) ) , [_THISROW_BEFORE].[ID Inspection Detail]<>[_THISROW_AFTER].[ID Inspection Detail])