lundi 6 juillet 2015

Remove dot(.) from amout value using sqlite query android

i want to remove dot(.) before decimal places in my amount value below is my database table enter image description here

Query

SELECT sum( REPLACE( REPLACE( amt, ',', '' ) , ' ', '' ) )

FROM amt_demo

when i run above query i give me below output

Output enter image description here

but i want total sum of value like

1333.00
100000.50
100000.00
123456789
123456789
123456789
---------------
370571700.50

any idea how can i solve this ? your all suggestions are appreciable

Aucun commentaire:

Enregistrer un commentaire