String Non Numeric

[gsmithmme]

I am using Crystal 8.5 with a Paradox database and customer has requested an average discount across 2 or more records. The discount field is a string field, so I tried ToNumber({eqlists.discount), which worked great until I had a discount that was 23.457E261, which of course is a 261 digit number and of course I got string is non numeric error. So, I am having a total brain fart, and cannot remember how to trim everything after the third decimal place so I would only use 23.457 for my average.

I feel like a schlub asking, but I am in a hurry, so advice is appreciated.

 

[lbass]

Try:

tonumber(left({table.string},6))

-LB

 

[gsmithmme]

Thanks so much..