Error : String is Non-Numeric?

[Hawk45]

I am creating a formula to put into a cross-tab that will show a %. I am using the following formula.

CDbl ({Total_View.total})

I am running into 2 problems:
1. When I try to use the above formula in the report detail section, it returns with the error message of "String is Non-Numeric".

2. I tried to use the following formula first to put into the cross-tab, but even though the formula was saved, it would not show in the cross-tab formatting box as a Summery Field option. Why?

PercentOfCount ({ALL_Ideas_for_Crystal2._13})

Thanks,

Hawk

 

[Hawk45]

Sorry, I forgot to mention that both are "strings".

Hawk

 

[Ngolem]

first of all is this the complete formula??

CDbl({Total_View.total})

Secondly, you say that {Total_View.total} is a string. perhaps it is non-numeric sometimes.

third why don't you simply use a tonumber() function instead or Val()
Jim Broadbent

 

[Hawk45]

I have tried ToNumber() and it also returns "Non-Numeric String". This is the whole formula. All I want is the value of .Total. Any other suggestions?

 

[dgillz]

Create a record selection formula to find the offending data as follows:

NumericText({fieldname}} = false

See if that spawns any new thinking Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Hawk45]

No, showed nothing? Anything else. I would hate to have to manually build one of these. Sounds like a horror story.

 

[dgillz]

Wow. Have you tried verifying the database? Click on Database, verify database and let me knwo what happens. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[dgillz]

Wow. Have you tried verifying the database? Click on Database, verify database and let me know what happens. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Hawk45]

Says "Database is up to Date"

 

[dgillz]

I am at a loss. Can you email me the report with saved data and I'll take a look at it. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Hawk45]

Sure, I would appreciate that.....!!!! Thanks!

I will mail you in a few.

 

[dgillz]

Every single field in your database shows as string and 254 characters when you look at it through the field explorer. Why is that? Is this a database that you created?

Also, please try:

tonumber(totext({Fieldname}))

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Ngolem]

there are some kind of characters in your datafield that are non-numeric....perhaps blank spaces??

do this make a test formula

@Test

whilePrintingRecords;

{FieldName} + "has this many characters: " +
totext(Length({FieldName}));

if the number of characters you count in the field name doesn't match the number shown then you fields are padded with blank spaces or other non-printable characters.

Perhaps, ToNumber(trim(FieldName})) ,would work Jim Broadbent