Why am I getting this error? The field is a ...

(Tammi Canelli) #1

Why am I getting this error?

The field is a number and only numbers are in the column.

(Bellave Jayaram) #2

Try SUM(SELECT(Medical Needs Program Registry PENDING[# persons evacuating],true))

(Tammi Canelli) #3

That expression does work but it’s not showing up in the col where I put the app formula.

Any idea why this would be?

(Tammi Canelli) #4

Solved - didn’t realize I needed to open and save the form view before it would total.

Now I just have to figure out how to count non-number columns.

(Aleksi Alkio) #5

Well… method for the counting is the same. You just use COUNT instead of SUM.

(Tammi Canelli) #6

Thank you.

I did get them all to work!

Most exciting thing that happened yesterday