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

    Covert IF Condition into set analysis

    Vignesh Kumar

      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