IF THEN Question

[herschelrj]

I am adding an IF THEN Statement to a display string.

IF Count ({PS_EMPLOYEES.EMPLID}, {PS_EMPLOYEES.JOBCODE}) > 100 THEN "Needs Attention"
ELSE CurrentFieldValue

I can't get the current field value to display if less than 100. It is coming up blank...

Please HELP!!!

Thanks
herschelrj

 

[rosemaryl]

Dear Herschelrj,

Hmmm, interesting. I just tested this and I get expected behavior. When you say display string, you do mean right clicking on a field, choosing the common tab and then the formula editor next to Display String, correct?

Here is the formula I used:

IF Count ({Incident.Incident #},{Incident.Open Date & Time},"daily") > 100 THEN "Needs Attention"
ELSE
totext(currentfieldvalue,'#')
//I had to use totext as the field I performed this on
//is numeric.

What is the data in currentfieldvalue field?

Regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762