Issue with counting none blank cells in database

Hello,
I am trying to have my system count how many additional services have been provided. To do so I am counting how many times the “additional service price” section has a number in it that represents the usage amount. For example if there are 3 uses of additional services and the additional service price section is $15, $12, $15, I want to show the user “3”. Right now to do this I am using the “is not empty”:count function but it is not working. It seems to just be counting every single cell for some reason. I will add photos below. Any suggestions would be great.

Screenshot 2023-11-04 at 11.33.01 PM
Screenshot 2023-11-04 at 11.33.24 PM
Screenshot 2023-11-04 at 11.33.45 PM

Hi there, @danieleyny… click on the search and add a constraint where Additional Service Price isn't empty and then add the :count operator right after the search.

Best…
Mike

1 Like

Thank you!!! This worked, I’m embarrassed that the solution was that simple lol.

1 Like