new variable in designer based on IF statment 1

[vld]

Hello

Is it possible to create a new variable in BO based on if statement. I want to do this at the designer level. I know how to do this in the report level.

For example we want to create a variable called SICK,

If NJ_EPSD.BODY_SYS_CNT =5 and NJ_EPSD.disease_stag_cd =3 then sick =1
Else
Sick =2


Thanks for your time

 

[Gunnien]

Hello,

It is possible, i truied this on the eFashion universe and it parses OK

IIf(Calendar_year_lookup.Yr = 2004,"OK","NOT OK" )

Hopes it helps you

Kind regards Gunnien

 

[blom0344]

The general solution that is supported by most databases is the CASE statement:

CASE WHEN Calendar_year_lookup.Yr = 2004 THEN "OK" ELSE "NOT OK" END

The IIF statement is NOT supported in server type databases, but with Efashion it parses, cause this is an MS Access backend...


Ties Blom
Information analyst