Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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)
=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)
Thank you gysbert!