Syntax for WebIntelligence XI variable...?

[MJRBIM]

Can anyone tell me how to create a WebIntelligence variable that would have the same functionality as the Crystal Reports formula below written against the same universe...?
____________________

IF {Universe.Grade Code} IN ["K4","K5","01","02","03","04","05","06"] THEN "Elementary [K-6]"
ELSE
IF {Universe.Grade Code} IN ["07","08"] THEN "Junior High [7-8]"
ELSE
IF {Universe.Grade Code} IN ["09","10","11","12"] THEN "Senior High [9-12]"
ELSE
IF {Universe.Grade Code} = "SS" THEN "Special"
ELSE "N/A"

____________________

I just don't understand the SYNTAX structure for WebI...

Thanks in advance for the help!

 

[skrandel]

The syntax is pretty much like Excel.

if(true_condit;then;else)

These can be nested.



Steve Krandel
Intuit

 

[hilfy]

Instead of "IN", you'll use "InList" in syntax that looks something like this:

=If([Grade Code]} InList("K4";"K5";"01";"02";"03";"04";"05";"06"); "Elementary [K-6]"...

-Dell


A computer only does what you actually told it to do - not what you thought you told it to do.