@mhouston Bingo. Using AND not OR, and using an equal instead of like both fixed the issue and corrected the count. Thank you both @Billobi and @mhouston for helping!

@Billobi This does work but by using this, I actually found that one of our locations has their bay text defaulted to 'BAY 0' instead of 'No Bay' like the other locations. so I added this line to the beastmode: But this returns data for this one store in question that looks like this: when I remove not like 'No Code0No…