2 Replies Latest reply: Sep 29, 2016 2:21 PM by Mike Sawyer RSS

    Simple Count - Question

    Mike Sawyer

      Hello,

       

      I'm trying to count records using the formula:

       

      Count ([Unit Status]='Opened')

       

      But, this returns the count of all records in the file (121).  The actual count of 'Opened' is 48.

       

      Here's a snippet of the field in the data table.  I changed the name of the variable to 'Project Status' in this table, but it is 'Unit Status' in the source data file. 

      Open.JPG

      .

       

      Can anyone see what I am doing wrong?

       

       

      Thanks!