Count of records not working

Hi all,

I would like to count the records of table “Antrag Mobiles Arbeiten” by using this formula:

count(Antrag Mobiles Arbeiten[Nr])

but the result is always “0”.

What is my mistake?

Thank you for your kind help.

2 Likes

Maybe column [Nr] is empty?

1 Like

it is not empty, although there are some empty cells see screenshot

1 Like

What does ‘test’ from expression assistant shows?

1 Like

no data rows

1 Like

1 Like

you are right, this was different try, see here the empty table with count:

1 Like

Seems like the table were you have the COUNT() expression doesn’t have any data
Are you using any security filters?

1 Like

Thank you for your kind help, there are no security filters and the google sheet has a lot of test data

1 Like

Maybe this can be tried
COUNT(SELECT (Antrag Mobiles Arbeiten[Nr], ISNOTBLANK ([_RowNumber])))

1 Like

thank you and unfortunately no data

1 Like

Change type data
Number
No text

1 Like

I’d suspect the app isn’t using the worksheet you think it is.

In the app editor, go to Data >> Tables, to the Antrag Mobiles Arbeiten table, and click View Data:

Does it display what you expect?

2 Likes

Thank you @Steve you are right, the view data is empty.

But the view source opens the expected google sheet and adding records is working :exploding_head:

2 Likes

Hi all,
it is working now!

Unfortunately “Filter out all existing rows?” was checked because the solution should only collect new data. This prevents from reading existing data and the count(…) was not working.

Thank you for all this great help and your time to support me!

4 Likes