Thanks for the recomendation I’m learning how to post here and I will improve.
Let’s Try Again!!!
I have a Table called “Payroll”. here I enter the employee information when they won´t come to work.
The data I have to submit is:
*Employee ID - Type Number
*Name - Type Text (Which I bring to this table using a select formula conected to a data base of employees)
*Date, Time and Week number…
*Type - Type Text (To know the type of absenteeism)
*Date Start - Type Date (To know the start date when the employee is not going at work)
*Date Finish - Type Date (Due to…)
There I need to focus is in the Start date and finish date.
This is because in other table I’m trying to calculate the % of pople working every single day…
Let’s make an example:
I have 24 employees (Daily)
1 guy will be on vacation from 27/12/2020 until 10/01/2021
If I want to know today the % of people who isn´t at work I have…
Total employees = 24
Total absent employees = … This what honestly I don’t know how to solve, how can I get automatically this numer (Which should be = 1)