Convert to Number

[SMosley804]

DB=IBM DB2
Crystal Reports Developer v11

I have a field that stores values for various properties and those values contain both numeric and string values. I need to perform a calculation of the the numeric values and also return the string values as well

I've been playing around with a formula to accomplish this, but I receive the error: 'A string is required her'

My existing Fomula looks like this:

if not isnumeric(PropertyValue) then {PropertyValue} else
if isnumeric(PropertyValue} then
tonumber(PropertyValue)/1073741824

Is there another way that this can be done?


Ex.(current)

Group(Resource)--HDD0

Property PropertyValue
disk.size 73406611456
disk.model ST534CL2
(Needed)

Group(Resource)--HDD1

Property PropertyValue
disk.size 68.37
disk.model ST534CL2

 

[dbaJSmith]

try wrapping the calculation with a totext:

if not isnumeric(PropertyValue) then {PropertyValue} else
if isnumeric(PropertyValue} then
totext(tonumber(PropertyValue)/1073741824)

 

[Charliy]

The problem is that you're trying to assign both a string and numeric value to your output.

try this:

if not isnumeric(PropertyValue) then {PropertyValue} else
if isnumeric(PropertyValue} then
totext(tonumber(PropertyValue)/1073741824)

 

[SMosley804]

Thanks Guys! Although that didn't work exactly, it got me to where I needed to be. I did the following and it worked perfectly.

if not numerictext(ProperyValue) then {PropertyValue} else
if numerictext(PropertyValue) then totext(tonumber({PropertyValue})/1073741824)