Converting String to Numeric

[davidmo]

I am trying to convert a string to numeric format so i can summerize the amount. any help would be great.

 

[synapsevampire]

Try:

val({table.field}) in a formula, and then do your summary against the formula.

-k

 

[davidmo]

I created the formula val({initial.amount}) and when i refreshed the data it made all the amounts equal to 0. Not sure what I did wrong. What do I need to add or clarify?

 

[Ngolem]

this means that you have a non-numeric character as the first chracter of your string

Val reports numbers until it reaches a non-numeric character

eg.

Val("223abc&quot = 223.00
Val("abc223&quot = 0.00

now we get into numeric signs and they seem to cause a problem with Val

Val("+123&quot = 0.00

(this is weird but happens on my machine with CR 7)
Val("-123&quot = -23.00

I prefer toNumber actually

ToNumber("+123&quot = ***error*** non-numeric
toNumber("-123&quot = -123.00

there is still a problem with having a + sign but at least the negatives calc correctly...also you don't get a FALSE zero value as you would with VAL...you can always test with NumericText and strip off a "+" if this is the problem.

Jim Broadbent

 

[davidmo]

Thanks. I had $ at the front of the string so by eliminating that the formula worked.