2 Replies Latest reply: Oct 27, 2011 10:16 AM by Swarup Malli RSS

    A very challenging requirement  using   set analysis ?

    Swarup Malli



      i have a requirement , where i have to write a set expression with the requirments given below




      i have to find the sum of donations by employee ,

        - with distinct account numbers  ( field name is      indacctno)

      - exclude account number starting with zero

      - where totaldonation > 0 ( field name is totaldonation ) in a year ( year is a field)


      this is what i have written , now i have to implement the above requiremnts in the expression given below .

      sum ({$<CAMPAIGNTYPE ={'Empl'}>} DCDetails.TOTALDONATION)