Can Someone explain why this function not working?

[aydiniletisim]

Hello I put a KPI in dashboard write this formula but it did not bring any results. Can someone explain why it did not work?

=Avg({$<INTERESTRATE<=1.42>}INTERESTRATE)

I want to find average interest rate for interest rates below or equal to 1.42 .

[BrunPierre · Accepted solution]

=Avg({$<INTERESTRATE={"<=1.42"}>}INTERESTRATE)

[aydiniletisim]

Qlik Sense says your function is correct but gives no result. 

If i write in this form it gives correct result : =avg(if(INTERESTRATE<1.42,INTERESTRATE))

[aydiniletisim · Accepted solution]

your formula works when  1.42 changed to 1,42. Thanks.

=Avg({$<INTERESTRATE={"<=1,42"}>}INTERESTRATE)