How to count without null values?

[gireesh1216]

Hi all,

I want to count employees based on Ticket_No.If Ticket_No is null no need to count employee. Please find my below query.

=count({$<Emp_Status={'Completed'},Ticket_No={'>0'}>}Ticket_No)

help me

[Anonymous]

Hi Gireesh,

Try below expression.

If(Emp_Status='Comlpeted' and not isnull(Ticket_No),Count(Ticket_No))

Warm regards,

Venkata Sreekanth

[diego_vazquez]

Hi,

try the following expression:

Count(

     If(Emp_Status = 'Completed' AND not isNull(Ticket_No),

          Ticket_No

     )

)

[jonathandienst]

I recommens that you disregard ALL of the above responses except for Marcus Sommer's answer, as they are either wrong or do unnecessary extra work.

[gireesh1216]

Ok i will try