2 Replies Latest reply: Oct 12, 2016 1:54 AM by Jim Chan RSS

    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