how to len(trim) with set analysis?

[jim_chan]

Hi guys,

I have an expression, now i want to add in 2 more condtions = A_Rate_Name = 'Low' and B_Rate_Name = 'Low'. How should I add it into this expression?

=Count(DISTINCT {<Record_ID = {"=Len(Trim(Only({<Year,Rating, Record_ID = P(Record_ID)>}Rating))) = 0"}>}Record_ID)

rgds,

Jim Chan

[Gysbert_Wassenaar · Accepted solution]

=Count(DISTINCT {<A_Rate_Name ={'Low'}, B_Rate_Name = {'Low'}, Record_ID = {"=Len(Trim(Only({<Year,Rating, Record_ID = P(Record_ID)>}Rating))) = 0"}>}Record_ID)

[jim_chan]

Thank you gysbert!