Total Count of rows with a specific value in field

[#1]

Hi,

I have a column called withinresp, where the result is either going to be 0 or 1.  However I would like to know the exact number of the value 0, in the field called withinresp using a text object.  Would someone be able to help me with the query please?

[Nicole-Smith]

=count({<withinresp=0>}withinresp)

[giakoum · Accepted solution]

count({$<[withinresp]={0}>} withinresp)

[#4]

if we need to count distinct value then plz help

[anbu1984]

=count(distinct {<withinresp=0>}withinresp)

[#6]

Thanks a lot

it is working fine with below mentioned expression

count(distinct {$<[withinresp]={0}>} withinresp)