I need Help badly. 1

[shekurbuti]

Hello,

I have a report in Crystal Reports 8.0 that scores projects.
(examples: project 10201 = 20 points, 10201a = 20 points).

I need to write something that changes this to all projects without a letter of the alphabet is = 20 points and any project that ends with a letter of the alphabet is = 10 points.
(example: project 10201 = 20 points, 10201a = 10 points.

Any ideas?

Thanks in advance!!

 

[vidru]

Try using the IsNumeric funtion in a formula:

if IsNumeric({table.field}) then 20 else 10

-dave