Slider&Custom condition

[aisolomatin]

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).