Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to derive field name STATUS at Script level.
Where the condition should be derived based on :
If an Employee is Review by his manager on weekly basis . if his rating is good or bad for that it should be BAD . if it is GOOD then it is GOOD ,If it is BAD it should be BAD.
Note: If weekly Review once falls under BAD then it is BAD .
Week | EMP ID | Review by Manager | Status |
23 | A | GOOD | BAD |
23 | A | GOOD | BAD |
23 | A | BAD | BAD |
24 | A | GOOD | GOOD |
24 | A | GOOD | GOOD |
24 | A | GOOD | GOOD |
Hi,
Quite not clear about the condition. Could you please elaborate the condition ?
If a employee is review by his manager as bad then status is BAD .
If We check from the above data Week23 employee is review by his manager is good ,good ,bad . then status should be bad .
May be you can take a count of 'BAD' aggregating on EmpID and Weekly basis.
If that count is greater than 1, you can mark status of that employee as 'BAD'.
E.g
=If(Aggr(Count({<[Review by Manager] = {'BAD'}>}[Review by Manager]),[EMP ID], Week)>0,'BAD','GOOD')