Text to Number

[Former Member]

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

[ido_millet · Accepted solution]

Val({VOESHIDO2.TRANSPTOTAL})

[Former Member · Accepted solution]

Val({VOESHIDO2.TRANSPTOTAL}) did the trick....

Thank you,

Debbie

[Former Member]

Hi,

Try this:

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

--dj

[Former Member]

It gives me the same results as my formula.

It removes the $ and I get 9,53.....but I now need to do a summary of this field. And this is where it is not working.

Tks,

Debbie

[Former Member]

Hi,

Can you please provide example output of your summary field..i.e 9,53

--dj