Help

Conditional Count Field Dysfunction

Topic Labels: Data
86 2
cancel
Showing results for 
Search instead for 
Did you mean: 
dbavli
4 - Data Explorer
4 - Data Explorer

I have a table with a count field that is supposed to count the number of linked records in another field that meet certain conditions. For some reason, the count field is not properly filtering the conditions and is counting ALL linked fields. I am not sure why this is happening as I have set this up properly. I have checked off "Only include linked records from X table that meet the following conditions" where "Status" has any of "X, Y." It is still counting fields where the status is not X or Y.

Does anyone know why this might be happening and how to fix it?

2 Replies 2

Hey @dbavli!

Would you mind sending a screenshot of your Count field and how the condition has been set?

Please make sure that the condition is set in the count field -not in the linked record field (such condition on the linked record field achieves a different outcome). 

Mike, Consultant @ Automatic Nation

As a data point, it seems to be working fine for me:

Screenshot 2025-01-02 at 8.40.46 AM.png

Screenshot 2025-01-02 at 8.42.10 AM.png

Screenshot 2025-01-02 at 8.42.13 AM.png

Link to base