Need to convert from metric to standard - problem I can't solve

[JSeidel]

I need to convert a field from metric to standard but the field is a ValueText field and I have to create a ToNumber formula first but when I execute I get an error - any help would be apprec

 

[synapsevampire]

What's the error and what did you try?

I'm not familiar with a ValeText field, a quick search showed something in Lotus...

To convert a text to a number, try a formula with:

if isnumeric({table.field}) then
val({table.field})
else
0

The key is to understand your data, and when posting here, share specifics, such as version of crystal, type and version of database, errors received, etc.

Otherwise you'll likely get vague responses.

-k