Am I doing it right?

[#1]

I'm trying to find the percentage of one specific group of ethinic_origin vs overall ethinic_origin for a specific date.  The table contains data from nearly 20 years details by starting of each month  

=

num((Count ({<
ETHNIC_ORIGIN = {'Asian (Not Hispanic or Latino)',
'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',
'Black or African American (Not Hispanic or Latino)',
'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',
'Hispanic or Latino',
'Two or More Races (Not Hispanic or Latino)'
},
Year= {$(=max(Year))

>}

DISTINCT [EMPLOYEE_NUMBER])/
count(DISTINCT [EMPLOYEE_NUMBER]

)), '#,##0%')

Please advice

Thanks

[Gysbert_Wassenaar · Accepted solution]

You're missing a closing curly bracket for the Year filter: Year= {$(=max(Year))}. The rest looks ok to me.