Help with Crosstab and Computation error

building reports desktopintelligence
1

All I have a crosstab and when I add my variables it produces the computation error.

Here are my formulas
Dimension
“BG LabResults”=ToNumber(Trim(SubStr(<Lab Result Value - Order Result> ,1 ,3)))

Measure
“UnitDailyGBResults” = =Average() ForEach (<Facility Id - Patient> , ,)

“BG 70-180 mg” =If ( >= 70 And <= 180) Then 1 Else 0

The BG 70-180 variable produces the computation error
I have 4 other variables like this to test what range the results fall in. all produce the error

Any thoughts on how to resolve

THanks
Steve

steve1040 (BOB member since 2012-02-25)

2

Nevermind I found the issue

Change this:
If ( >= 70 And

to this

If ( >= 70 And

steve1040 (BOB member since 2012-02-25)