3 Replies Latest reply: Feb 24, 2016 10:34 AM by Gysbert Wassenaar RSS

    Covert IF Condition into set analysis

      Hi Folks,


      I have a problem converting if condition into set analysis


      i have variable expression, I need to simplify in set analysis. Can anyone help this .



      If(IF(Payment = 'NET' AND Payment_Discount<>0 ,1,0)=1,

      -(TCNET * NumberOFTrans ) + (Annual_Trans * (PaymentDiscount_PerDays+AvgNET) /365) * FundRating

      + Annual_Trans * Payment_Discount )



      Kindly help to convert the above expression in set analysis.


      I tried but still there is expression error.


      Thanks in advance

      Vignesh kumar