Report filter based on array length

[Lawson02]

I have a field called numPick which is a checkbox field that can contain multiple things, for ex AAA123, AAA122, AAA121. Is it possible to create a report filter that filters out projects that have more than one checked?

Projects I want:

numPick: AAA102

Projects I don't want:

numPick: AAA123, AAA122, AAA120

[skyehansen]

I think if you make a calculated field and then filter off that calculated field, this would be the easiest.

So if for example, you created a calculated field called numPick-CF, and the calculation would be {DE:numPick}.

Then your report filter would be

DE:numPick-CP=AAA102

DE:numPick-CP_Mod=cieq

[Lawson02 · Accepted solution]

Thank you very much for the response, it set me on the right path! I am going to filter my report using

DE:numPick=,

DE:numPick_Mod=cinotcontains

This way any project with more than one numPick is filtered out because since numPick is a checkbox field it separates multiple using a comma.