4 Replies Latest reply: May 8, 2018 10:41 AM by Derek Ledbetter RSS

    If condition in set expression

    swati moku

      Hie...I want if condition to be applied in the set expression can anyone please help me out.



      Set expression:

      if(NO=7,(SUM(Aggr(Sum({<[P.HOLD_FLAG]={'N'},[P.DUE_DATE]={'<=$(vMaxDate)'},[P.Division]=Division>}[P.PAYABLE_AMOUNT]),

      [P.DUE_DATE],Region)))/vDenom 




      If condition to be included in set:

      (vMaxDate-[P.DUE_DATE])>=0 and (vMaxDate-[P.DUE_DATE])<=15

        • Re: If condition in set expression
          Sunny Talwar

          Not sure I understand... would you be able to provide a sample?

            • Re: If condition in set expression
              swati moku

              Hie sunny,

               

              Following is the example:

              payable:

              hold_flag,

              amount,

              status,

              due_date,

              p.division,

              region

               

               

              Island_table:

              date,

              division

               

              created a varialbe: vMaxDate=max(date)

               

              for selcetion fields on the sheet I am using Island table fiels, So I am using the fields in set to compare the payable field.

               

              the following is the expression:

              (SUM(Aggr(Sum({<[hold_flag]={'N'},[p.division]=division>}amount),due_date,region)))


              now i want I more condition that the amount following in 0-15, 16-30,31-60,61-90,>90 days with respect to the selection made on the sheet.



              (vMaxDate-due_date)>=0 and (vMaxDate-due_date)<=15


              Following is the screenshot:

              commuity.PNG

               

              sum of days bucket should be CM.



            • Re: If condition in set expression
              Derek Ledbetter

              Good Morning,

               

              If I understood, it appears an "Intersection" is needed in the set.  Below is my example as I just worked on this yesterday.

               

              Hope it helps.

               

              What this is doing is a "intersection".  It states (count (IF the Intersection is >=1 and <=72). (THE * is the intersection of "both SETS".

               

              Count({$<HoursBetweenEDVisits={">=1"}>
              *
              <
              HoursBetweenEDVisits={"<=72"}>
              }
              CSN)