5 Replies Latest reply: Jul 31, 2012 11:39 AM by Rahul Lakhina RSS

    Adding set analysis to count function

      Hello, I have a functioning expression :- count(if(mid(Move_Out_Date,4,2)='08'and (mid(Move_Out_Date,7,4)='2011')and left(Post_Code,4)='SO15','Count'))

       

      I am trying to add a bit of set analysis to this expression and its not liking it, here is what I am trying :-

       

      count(if(mid(Move_Out_Date,4,2)='08'and (mid(Move_Out_Date,7,4)='2011')and left(Post_Code,4)='SO15' and Count({< Installation= {">1"} > } CA),'Count'))