COUNT SYNTAX

[#1]

I have to count all the '1' numbers in the column 'RequestStatusID'

The column contains the numbers 1,21,922,etc......

I tried to use count but I had problems with the syntax....

Thanks

[SunilChauhan]

count({<RequestStatusID={'1'}>} RequestStatusID)

or

count(if(RequestStatusID=1, RequestStatusID))

[alexandros17]

Sum(If(RequestStatusID=1,1,0)

if you use count with the same expression even 0 values will be counted ...

let me know

[rajeshvaswani77]

Hi,

You can use Sum(If(RequestStatusID=1,1,0))

thanks,

Rajesh Vaswani

[ashwanin]

If you have 1 always in front

=Count({<RequestStatusID={'1*'}>} RequestStatusID)

If you have 1 anywhere in field (e.g 210)

use : =Count({<RequestStatusID={'*1*'}>} RequestStatusID)

[#6]

Thanks,

Now Each RequestID belongs to MeterID

I would like to count the RequestID per unique MeterID

How do I add DISTINCT to the second count you wrote me in your last answer?