Dear Kevin

Try this

EVAL �IF FIELD.NAME[1] = �*� THEN 1 ELSE IF INDEX(FIELD.NAME,'Incomplete',1)
THEN 1 ELSE 0"

Regards

Sami Pierre Massarany
Mobile: 0414 408 229 or +61 414 408 229

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Kevin Michaelsen
Sent: Friday, 6 February 2004 3:14 AM
To: [EMAIL PROTECTED]
Subject: EVAL and LIKE

I'm trying to get this statement to work:
Basically I'm trying to count the number of records that have a FIELD.NAME
that has an "*" or an "Incomplete".

TOTAL EVAL "IF(WITH FIELD.NAME LIKE "'...*','Incomplete'") THEN COUNTER ELSE
0"

Thanks for any assistance.

Kevin
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to