Counting across Columns

[Work_Goscinski]

I have read about counting across multiple columns.

I have created an audit app. My users have to check multiple random parts before they ship. I have hundreds of part numbers. They can check up to 12 parts per audit. The same parts may not end up in part number 1 column. SO I need the ability to see if a part number occurs in any of the 12 columns.

I created a virtual column with this formula

Next I created a slice called # of Parts checked.

Then I created a view

However, as you can see in the data sheet:

there should be 4 instances of 16 13643 000

Clearly, I am missing something. Just not sure what.