Results 1 to 2 of 2

Thread: ToText Error

  1. #1
    Join Date
    Aug 2004
    Posts
    15

    Unanswered: ToText Error

    I need to convert a text field to a number to process a calculation. When the report was written they used ToNumber({PATIENT_LABS.result}) which has worked great for years. However the lab company has started sending results that cannot be converted from text to numeric such as <2.5 or "Pending".

    Crystal bombs because it cannot convert "<" or letters to a number. What function or process can I use to determine if in fact my lab result is able to be converted to numeric.

    In SQL I could use isnumeric()

    Philip
    Crystal 7

  2. #2
    Join Date
    Aug 2004
    Posts
    15
    Found it!

    numerictext(str) = true

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •