You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Exclude members from @sumrange?

Summary:

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?


Content (required):

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!