2 Replies Latest reply: Nov 10, 2011 10:21 AM by Sergejs Kazakevics RSS

    count and set analysis

    Sergejs Kazakevics

      Hello,

       

      I'm struggling with one set analysis expression. I've got a chart object like this:

       

      AccounIDAccountName
      Expression1Expression2 (Y or N)
      1111AAAA10N
      2222BBBB20Y
      3333CCCC30Y

       

      where

      Expression1:

      =count({$<CASHJOURNALTYPE.paymenttype={1},CashCalDate={">=$(=date(now()-1,'YYYY-MM-DD'))"}>}CASHJOURNAL.linkcashjournalid)

       

      Expression2:

      =if(count({$<CASHJOURNALTYPE.paymenttype={1},CashCalDate={">=$(=date(now()-1,'YYYY-MM-DD'))"}>}CASHJOURNAL.linkcashjournalid)>=20,'Y','N')

       

      Both expression works fine. But I want to get a count of AccountID's where Expression2 = 'Y' in separate text object. In my example expected result is 2. How the set analysis expression should look like?

       

      Any idea how to get it done would be highly appriciated. Thanks in advance!

       

      ~Sergejs