Text to Number Formula

[TEM3]

Using Oracle 9i Tables and Crystal Reports 8.5:

I have a test results field that is text and is populated with a variety of information {ARRESULT.Result}. For many of the records a number is entered (as text) representing the number of particular tests performed.

I need to create a formula that first tests the field to see if the text is a number (integer) and if so, and not zero, converts the text to numeric and sums the value of the filtered records.

 

[bdreed35]

Try this in a formula:

//@Convert_Result

if isnumeric({ARRESULT.Result})
then tonumber({ARRESULT.Result})
else 0

You can then sum this formula using the Insert, Summary command.

~Brian