3 Replies Latest reply: Jul 14, 2017 7:04 AM by Sunny Talwar 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