×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

could someone please tell me whats

could someone please tell me whats

could someone please tell me whats

(OP)
could someone please tell me whats wrong here.  this formula works fine in Report Designer, but after successfully running then, viewing it from Info Analyzer I receive the message "The string in non-numeric".

<labour hours is numeric>
 
StringVar X :=  toText(Sum({RO_LABOR_TA71.LABOR_HOURS}, {RO_ITEM_TA53.WIP_LOCATION}));
StringVar H;
stringVar M;
M := Right ( X , 2 ) ;
H := Left ( X  ,5 );
(toNumber((Left(toText(H),2))) + (toNumber((Right(toText(M),2)))) * .06 ) / 10  

i have changed this formula several times, it always works in designer, but errors out in info Analyzer
Thanks for your time and help!

RE: could someone please tell me whats

This normally occurs when you name specific character positions (in Left and Right formulas, for example)and your field isn't static.  For example, you'll see 12/31/2001 12:12:12 which is 19 characters in length Vs. 1/31/2001 12:12:12 which is 18 characters in length.  If your formula is ToNumber(Left(ToText({TableName.FieldName}),2) for the first date then the return is 12.  If your formula hits the second date it attempts to convert '1/' to a number and you get the infamous "The string in non-numeric" error message.

Try converting your Date Time values into String within your Report Options Form (File|Report Options).  You should then be able to parse your field correctly because the value will be converted into a static format (MM/DD/YYYY 00:00:00, for example).

RE: could someone please tell me whats

(OP)
Thanks Rhinok;  it was easier for me to do it in the SQL statement, i am better at SQL than CR  .. thanks for your help.. it was a good lesson for me
to_number(substr(ROL71.labor_hours,1,instr(ROL71.labor_hours,'.')-1)  || substr(ROL71.labor_hours,instr(ROL71.labor_hours,'.')+1) * .06 /10 ) as "LabHrs",    

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close