AnsweredAssumed Answered

PatternCount troubleshooting

Question asked by dbice on Mar 28, 2017
Latest reply on Mar 30, 2017 by philmodjunk

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?