If/Where Condition

system · March 30, 2005, 9:58pm

I’m getting Computation error when using if condition where works fine though. im giving the syntax below

If =“180” Then (<Mortgage Loan - Loan Amt>) Else 0

<Mortgage Loan - Loan Amt> Where (=“180”)

But my requirement is to use Not Equal to which i can’t use in relational operator form with Where <>
So I want to Use If Mortgage Loan Life Cd not equal to 180 then blablabla else 0.

Can anyone give me correct Syntax to help me.

Thanks

Lakshmi T (BOB member since 2005-03-30)

system · March 30, 2005, 10:15pm

I don’t think you need double quotes on 180.

xen (BOB member since 2004-11-13)

system · March 31, 2005, 12:05am

Please, take a look at this post in the Reporter FAQ.

Andreas (BOB member since 2002-06-20)

system · March 31, 2005, 3:51pm

Hey It worked by creating boolean variable. Thank u so much

Lakshmi T (BOB member since 2005-03-30)