How to use Case Structures in place of nested if

Team_2007 · Post by **Team_2007** » Sat Jul 28, 2007 2:57 am

Hi All,
I have a requirement as mentioned below.

If Dept_no=100 Or Dept_no=101 Or Dept_no=102 Or Dept_no=103 Then 1203.24 Else If Dept_no=104 Then 12345.89 Else 0

Can any one of you please tell me how to use Case Structures in place of Nested If Conditions.

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Sat Jul 28, 2007 3:16 am

Not possible in a derivation or constraint expression, which yours appears to be.

It is possible in a routine, but yours does not have the form of a set of nested IF statements (containing assignment statements) that one would expect to find in a routine.

chulett · Post by **chulett** » Sat Jul 28, 2007 7:09 am

As noted, you'd need to write a custom routine if you really felt the need to convert this into a 'case' statement. You would then reference the routine in your derivation.