Hi!
I'm stucked with issue and hope somebody helps me.
What we get:
1. Company with Branches, Divisions and Subdivisions;
2. Data about staff: number of Regular staff, number of Vacancies;
3. Time period: 2 months.
What we need to know:
1. How many Subdivisions/Divisions/Branches achived the plan for %_staffing (98%).
Formula for %_staffing = 1-Vacancies/Regular staff.
We got Staff_in_Subdivision and Vacancies_in_Subdivision sliders for flexibile subdivisions filtration.
For Date="01.01.2016"
If we set up Staff slider to 120, and Vacancies slider to 2, then we should get next result.
We excluded all Subdivisions, that have staff<120 and Vac<2.
And specific condition: if Division have only "n_a" Subdivision that fit to our condition (Staff>=120 and Vac>=2), then we don't need to count it (Division 22).