I’ve been playing around with the default Organizational Base template and have changed it in a way that it would perfectly suit our company, but got stuck at the last bit.
I have a tables with employees, clients, industries, etc. I wanted to register how employees are utilized sacross clients and have done so using junction tables. I have embedded a fake and simplified version of this below
my test table
As you can see I can define the percentage of time a single employee is utilized per client in the Client utilization table and I do a LookUp with a SUM(values) in my employee table to sum up the total amount of time an employee is utilized for any client at all. in this way I can check if he or she is available for more work or not.
Now the part where I get stuck.
I created a similar table as the utilization table where I can define per user how much time they prefer to work per industry. I want to compare this preferred time per industry with the total time per industry they are utilized in, but somehow I can’t figure out how to get this last thing working. If someone can help me with this I would be forever grateful!