count with condition

[Anonymous]

hay

i have 2 field one is the date and the second is the condition.

i wnat to know how much time  the condition 1 apear.

i use this one but i get nothing 😞

=Count({$<[condtion]={"0"}>}[date])

i need to count the date field ,just if the second field show 0  , how can i do that ?

thanks'

yarin

[nilesh_gangurde]

Heyy ,

Check out the field "condition" is in which format.

if its in text then it will not show anything for the above expression.

Regards,

Nilesh Gangurde

[thomas_skariah]

Hi Yarin,

Just try the following code =count(if(condtion=0,date)).

Regards,

Tom

[#4]

hi,

please try this expression

   =count({<[condition]={"=null()"}>}[date])

I hope this will help.