topic Re: Simple Count - Question in App Development

Simple Count - Question

msawyercke — Thu, 29 Sep 2016 18:01:12 GMT

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.

Can anyone see what I am doing wrong?

Thanks!

Re: Simple Count - Question

sunny_talwar — Thu, 29 Sep 2016 18:15:35 GMT

Try this:

Count({<[Unit Status]= {'Opened'}>} [Unit Status])

Re: Simple Count - Question

msawyercke — Thu, 29 Sep 2016 18:21:01 GMT

Wow - thanks, Sunny. Works like a charm!

I'll bookmark this in case I need to do something similar in another part of my app. You are the BEST!