Forum Discussion
Solved
Direct - Indirect Report Help
Hello, I am looking for some assistance with showing Direct and Indirect reports. This previous thread below provided a great start for myself but I am now trying to expand on this. https://com...
redwings00 Easiest thing would be:
Measure = IF(ISBLANK([Measure - Direct Reports]),BLANK(),LEN([Measure - Direct Reports]) - LEN(SUBSTITUTE([Measure - Direct Reports],",","")) + 1)
redwings00 Easiest thing would be:
Measure = IF(ISBLANK([Measure - Direct Reports]),BLANK(),LEN([Measure - Direct Reports]) - LEN(SUBSTITUTE([Measure - Direct Reports],",","")) + 1)
Greg_Deckler - Thank you so much. This works great to get the total counts. Would you know if it would be possible to show the names instead of the ID's?