Exclude members from @sumrange?
I am working in a labor cube, and I have a pool of bonus dollars that is to be split among upper level management, but not among non-mgr employees.
Is there a way to exclude members that are not managers using @sumrange?
Is there a better alternative to @sumrange or my current solution below?
I have 4 employees in a given department, but only 3 managers qualify for a bonus. Each manger will get a portion of the Bonus pool based on their overall portal of manager salary.
The formula is as follows:
Bonus = ( Salary / Total Mgr Salary) * Bonus Pool