Divide profit among employees who made the sale

539 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

There is a field {Profit} (Currency), another {Contribution} (multi-select) field that records the employees working on a particular sale. Now in another [Employees] table, I want to display the total share of the profit they are taking depending upon which sales they were involved in.
For example in Table 1, if a sale of $100 is made by Employees A and B, both should earn $50.
If a sale of $150 is made By Employees A, B and C, all of them should earn $50.
And in the Employees table, I want to write the sum of their profit.

So it depends upon the Employees that I add in the multi-select field in the row of that particular sale. But how can I divide the profit among those employees only?

1 Reply 1

Is your multi-select field a linked record field or a multiple-selects field? It should be a linked records field.

In the sales field, have a count field that counts the number of employees, and a formula field that divides the amount of the sale by the number of employees to find the pro-rated portion that each employee gets. (Or use s single rollup field that does both parts.)

Then in the employee table have a rollup if all the pro-rated portions.