XLSX Count and Filter

AppSheet AppSheet Q&A
, , , ,
1

In an XLSX Template, I am trying to count the number of entries in an “Incident Data” datasource where the “DOB Page Reference number” is equal to “DOB Unique ID”. The DOB Unique ID is from another table. It filters ok but when I just try and get the count, by putting the code below in it error.

<<Start: COUNT(Filter(“Incident Data”, [DOB page Reference number ]=[DOB Unique ID]))>><>

I get this error message which I need help with:

Error 1 : Task ‘New step’ Attachment template. Start expression ‘COUNT(Filter(“Incident Data”, [DOB page Reference number ]=[DOB Unique ID]))’ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the ‘Key’ column of the referenced table.

Thanks For Helping.

2

It’s ok, I managed to sort it. I didn’t think about the <Start:> and <> would infact expect a list instead of me simply wanting the number.