Sep 24 2021 02:45 PM
I have 3 years of HR data. I want to add a new column titled "Labor Count" which will have a formula that looks at the employee ID and month and enter in the decimal for the amount of times it appears to sum up to 1 for that specific employee. I have a pivot table that is showning the count of records verses the distinct employee count. Can someone help with how I can write the formula?
Sep 24 2021 03:57 PM