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.
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.