Skip to Content
avatar image
Former Member

Text to Number

I have a String field that I need to calculate. An example of this string is 9,53$ I have removed the "$" with the following

(Replace({VOESHIDO2.TRANSPTOTAL},"$",""))

I am now trying to change the field to a number but the ToNumber will not work. Any ideas how I can modify this field so I can do a summary on it ?

Thanks,

Debbie

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 23, 2014 at 05:24 PM

    Val({VOESHIDO2.TRANSPTOTAL})

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 23, 2014 at 04:52 PM

    Hi,

    Try this:

    Replace({VOESHIDO2.TRANSPTOTAL},"$"," ")

    --dj

    Add comment
    10|10000 characters needed characters exceeded