9 Replies Latest reply: Mar 15, 2016 7:20 AM by Henric Cronström RSS

    Set Analysis Expression

    Janani Reddy

      Hey Guys, i need help in writing a set analysis query for the below IF expression

       

      COUNT(IF((DATE - DATE1) <= 7 and DATE >= DATE1 and CATEGORY = 'CASA', ACCOUNTID))

       

      The query i wrote (pasted below), is not giving me the correct count of account id's

       

      COUNT({$< CATEGORY = {'CASA'}, ACCOUNTID= {'DATE >= DATE1'}, ACCOUNTID= {'(DATE - DATE1) <= 7'}>} ACCOUNTID)


      where am i going wrong?