I am using the following statement as a security filter to allow employees to only see their profit centers data based on the field [CenterNo]. I would like to allow users with “ALL” in the CenterNo field to see all data. What would be the best way to include that in the statement below?
AND(IN([Tract_No], SELECT(Tracts[TractNo], [Archive] <> “Y”)),IN([CenterNo],
[UserEmail] = USEREMAIL())))