BusinessObjects Board

If/Where Condition

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.


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

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

xen :india: (BOB member since 2004-11-13)

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

Andreas :de: (BOB member since 2002-06-20)

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

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