look at this
select distinct(ltrim(method)) "METHOD",
substr(datehourmin,1,8) "DATE"
to_num(currency)
from min_in
group by method,substr(datehourmin,1,8)
OK,
That means the one of more of the records has a non-numeric character in the currency field, so you would need to correct the data or exclude those records.
After that , you should be able to use the Sum(to_num(currency)) function in your query..
To Paraphrase:"The Help you get is proportional to the Help you give.."
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.