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

    A very challenging requirement  using   set analysis ?

    Swarup Malli

      Hi!

       

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

       

      where

       

      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)

       

       

      Regards

      Swarup