Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to have field containing reportees which counts Line manager ID when compares to Employee.
Employee ID | Line Manager ID | Reportees | Reportees |
86032967 | 86036821 | =COUNTIF($B$2:$B$9,A2) | 1 |
86036678 | 86036887 | =COUNTIF($B$2:$B$9,A3) | 3 |
86037883 | 86036678 | =COUNTIF($B$2:$B$9,A4) | 0 |
86000230 | 86036678 | =COUNTIF($B$2:$B$9,A5) | 0 |
86040205 | 86036678 | =COUNTIF($B$2:$B$9,A6) | 2 |
10001750 | 86032967 | =COUNTIF($B$2:$B$9,A7) | 0 |
86024971 | 86040205 | =COUNTIF($B$2:$B$9,A8) | 0 |
86000239 | 86040205 | =COUNTIF($B$2:$B$9,A9) | 0 |
Try like:
=SubStringCount(Concat(TOTAL [Line Manager ID], '-'),[Employee ID])
Try like:
=SubStringCount(Concat(TOTAL [Line Manager ID], '-'),[Employee ID])
It works just perfect...thanks for saving me from working on data model..