Forum Discussion
Employee Positions available
Hi Community,
I am trying to get a measure to calculate the positions available in the company based on the ideal and current headcount in each store.
So far, I have already calculated the measure to get the active employees in each store and in the company. My data consist of 4 tables: calendar table, store list table, employee table (code, name, hire date, termination date, store they are hired for) and the headcount table (store list with the ideal headcount approved by operations).
The measure should show something like this: if a store has the same active employees than ideal headcount then show 0, if a store has more active employees than the ideal headcount, the measure has to show 0, otherwise show the number of positions still to hire, and the total should be the sum of all the stores that have positions available, for example:
| Store | Active employees | Ideal Headcount | Positions available |
| 1 | 10 | 10 | 0 |
| 2 | 15 | 13 | 0 |
| 3 | 20 | 25 | 5 |
| Total | 45 | 48 | 5 |
Thanks for your help on getting this
2 Replies
Hello drgonm5 ,
You could just subtract the active from the ideal, and it will show if they're equal then zero else it will show the number of missing employees.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi Idrissshatila thanks,
The thing is "Active" is now a measure and "Ideal" is from a data table for all stores
