BOOLEAN IF THEN STATEMENT

[codingsupv]

I am trying to write an If/Then statement in Business Objects report writer and am coming up with a Boolean variable error. This is what I was trying:

= If (<Procedure Code>="G9142") Then "90663"
The error I am receiving is:
Bad Variable type
You must create a Boolean variable

If I were doing this in Access, it would look like this:

Iif([Procedure Code]="G9142","90663")

I am a real novice at this, so any help would be greatly appreciated! Basically what I am trying to do is replace the code G9142 in the procedure code column with code 90663.

 

[elsenorjose]

Hi,

First of all, you don't need the = sign in front of IF. Second, the format of your 'Procedure Code' looks odd in Crystal. Fields usually look like {table.field} Is this actually how it appears in your report?

 

[elsenorjose]

Oh, forgot one more thing: You don't need the parentheses around the field name. And what should display if the field value is not = G9142?

if {table.field} = 'G9142' then '90663' Else 'some other value'

 

[lbass]

If you are using Crystal Reports, then I'm guessing you are creating this formula in the wrong area. You should go into the field explorer->formula->new and create the formula there and then drag it onto the report.

-LB