How do I get a count of one data element that...

(Tammi Canelli) #1

How do I get a count of one data element that is filtered off another?

I tried this but get a mismatch error:

=COUNT(SELECT(LIST([EvacLocationCenter]=“Lamarque”, dbo.Registration[LastName], TRUE)))

(Jacob Lin [AppSheet]) #2

Your SELECT inputs are not in the right order. The syntax should be in this situation: SELECT(some list, true). This reads: Select from some list where this is true.

COUNT will just count how many things are in the list you just selected, so that’s not the problem here.

For your specific expression, it should be something like: COUNT(SELECT(dbo.Registration[LastName], [EvacLocationCenter] = “Lamarque”). If this expression doesn’t work, give me a little more context (table names, column names, how the different things are related) to work with.