Help! Trying to do the now mandatory California Pay Data Report (CA Civil Rights Dept) - it breaks down job classifications w/ "Race-Ethnicity-Sex" codes.
My problem is that they want the ANNUAL income (W2 box 5) for ONE select 2-week pay period in 2022 Q4. I have on average 120 hourly employees with quite a bit of turnover. How on earth shall I run a report for JUST those employees for my 2-week pay period in Q4 but show the annual wages for only those working that period?
They call this section of the report "Pay Band" and I have to break down how many people of certain race/ethnicity/sex make annual wages in certain ranges. I am going to pull my hair out - HELP????
