Count of records not working

[Joachim_Mund]

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.

[SkrOYC]

Maybe column [Nr] is empty?

[Joachim_Mund]

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

[SkrOYC]

What does ‘test’ from expression assistant shows?

[taufiq_qurohman]

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

[Joachim_Mund]

no data rows

[SkrOYC]

[Joachim_Mund]

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

[SkrOYC]

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

[Joachim_Mund]

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

[Joachim_Mund]

taufiq_qurohman:

COUNT(SELECT (Antrag Mobiles Arbeiten[Nr], ISNOTBLANK ([_RowNumber])))

thank you and unfortunately no data

[taufiq_qurohman]

Change type data
Number
No text

[Steve]

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?

[Joachim_Mund]

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

[Joachim_Mund · Accepted solution]

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!