Indicator kpi : count with multiple condition

[StellaPao]

Hello,

I want to create a kpi using the function "count" to track the number of late findings who have a level equal at 2.

I try the expression below but it doesn't work. It return 0 instead of the number of late finding.. 

Count( {<[finding level]={"*2*"},[closure date] ={' '}, [due date]={'<=(today())'}>}[finding text]) 

The problem is on the condition [due date]. Without this condition, the expression return the correct number of findings in progress. 

Thank you for your help ! 

[marcus_sommer · Accepted solution]

Try it in this way: ... [due date]={"<=$(=today())"} ...

[StellaPao]

It works! Thank you very much !