I need to find the total number of rows (patients) and divide them into equal buckets. Then assign them to a staff member.
Example: 2 employees need to share work as equally as possible. There happens to be 4 rows (patients) in the report today, so each should be assigned 2 patients. If tomorrow there are 12 patients, each should get 6, etc.
I currently have 2 fields: Patient# and Staff Name
How can I do this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.