I have attached a file with a bare bones version of a scoresheet I'm trying to make. I want to use PatternCount to count how many times a participant scores 3 consecutive zeros. Right now, the formula is PatternCount(Time2_REMA_PartA ; "0¶0¶0" ). This is working well minus item #5, which uses a calculation to come up with the item total. The formula excludes that as a zero, even though the calculation is set as text. Is there another way to do this or am I missing something?

Try adding & ¶ to the end of the Time2_REMA_5_cardmatch_total field.