8 Replies Latest reply on Mar 30, 2017 8:47 AM by philmodjunk

    PatternCount troubleshooting

    dbice

      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?