![Ayush_Narang Ayush_Narang](https://community.airtable.com/legacyfs/online/avatars/3X/e/4/e49ee902f97465089abfc478e05fc3c8a71d452e.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2022 06:39 PM
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?
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2022 07:40 PM
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.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)