This content has been marked as final. Show 3 replies
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