Syntax Error

system · June 28, 2010, 6:19pm

Trying to create a variable at the report level using an If statement and I am getting errors. The data type is character. I want it to say:

If Level is equal to zero, then blank else level. Here are the functions I have tried with no luck:

If ([Level]=000;" "; [Level])

If ([Level]=“000”;" "; [Level])

Any suggestions on what I am doing wrong?

nthompson (BOB member since 2009-03-30)

system · June 28, 2010, 6:34pm

Disregard this post as I got it to work.

nthompson (BOB member since 2009-03-30)

system · June 29, 2010, 1:40am

How did you get it working? By replacing “000” in your code by “0”?

Jansi (BOB member since 2008-05-12)