Checkbox Pattern Count
I have checkboxes and pattern counts set up so that I can count the number of specific text strings. For example, in a field where I can check Europe, North America, Asia etc, I have pattern counters set up that can count the number of times Europe occurs in each field and also have summary counters that give me the amount of times Europe occurs in the entire database.
I have 600 records that ticks Europe, North America, or only Europe or only North America. When I add up all the individual pattern counts( Total Pattern Counts), i.e Europe+North America, I get 702. This I assume is because something is being double counted. What am I doing wrong?