Calculate the sum of a varchar field containg numbers...

[saramaia]

Hi!

I have a field in my database table that is a varchar2 but will always contain numbers.

How can i sum this value, considering it´s type is varchar2???

Thank you

Sara

 

[goranm]

Hi !

Maybe this can help:

Create a formula like this:

if IsNumeric({YourField}) then
val({YourField})
else
0

Place the formula in your Detail section and then you can summarize it.

/Goran