RE: [U2] NESTING EVAL

2005-10-25 Thread DAWES, Ray
I would think that you do that as just one EVAL - remove the second EVAL. Ray -Original Message- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 16:01 To: u2-users@listserver.u2ug.org Subject: [U2] NESTING EVAL Can I nest when using the EVAL command. Here is my

RE: [U2] NESTING EVAL

2005-10-25 Thread rbl000
You don't nest EVAL's, you nest IF's. I would rewrite your expression for clarity this way: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS NE Y) THEN 0 ELSE IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 Or perhaps: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS = Y) * (H.HCG.AWARDED.ALL 0) THEN 1 ELSE

RE: [U2] NESTING EVAL

2005-10-25 Thread Ray Wurlod
Nested EVAL is not supported. However, nested IF is supported, at least to a certain level of complexity. LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS = 'Y') THEN IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 ELSE 0 Or, even easier, since 1 is true and 0 is false: LIST CS.2005 TOTAL EVAL

RE: [U2] NESTING EVAL

2005-10-25 Thread David Knight
@listserver.u2ug.org Subject: RE: [U2] NESTING EVAL You don't nest EVAL's, you nest IF's. I would rewrite your expression for clarity this way: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS NE Y) THEN 0 ELSE IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 Or perhaps: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS