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
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
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
@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