Multiple between in set Analysis

[sutoniusahadong]

Dear All,

i didnot find the formula about multiple between in set Analysis, can any body help ? please...

"=Count(DISTINCT {<EMPLOYEE_NO = {"=if(isnull(SCORE_MQ),0,Avg(SCORE_MQ)) >= 80 and (Avg([A/T])>=0.7<0.9) and (Avg(BOBOT)>=1.6 <2.05)"}>} EMPLOYEE_NO)"

the result in Yellow not match

Tq

Toni

[sunny_talwar]

May be this

=Count(DISTINCT {<EMPLOYEE_NO = {"=Len(Trim(SCORE_MQ)) > 0 and Avg(SCORE_MQ) >= 80 and Avg([A/T]) >= 0.7 and Avg([A/T]) < 0.9 and Avg(BOBOT) >= 1.6 and Avg(BOBOT) < 2.05"}>} EMPLOYEE_NO)