6 Replies Latest reply: Apr 17, 2018 11:42 AM by Sunny Talwar RSS

    Set Expression with <  >

    NEVILLE DHAMSIRI

      Hi Experts,

       

      Please help me to achieve following out put!

       

      As for the 1st expression, if I am to say MONTH_PROVISION> 1000 & <2000000, how it could be included in to this set expression?

      As for the 2nd expression, if  I am to combine  MONTHS_PROVISION +UNDER_OVER_PROVISION & to say if both   MONTH_PROVISION  & UNDER_OVER_PROVISION added together & resulted figure if <500000,then what the outcome is

       

      SUM({<CLASS_CODE-={'MC','M4','M3','CH','PP'},MONTHS_PROVISION={"=MONTHS_PROVISION<2000000"}>}MONTHS_PROVISION)

       

      SUM({<CLASS_CODE={'MC','M4','M3','CH','PP'},UNDER_OVER_PROVISION={"=UNDER_OVER_PROVISION <2000000"}>}UNDER_OVER_PROVISION)

       

      Many Thanks

       

      Neville