2. ASPRunnerPro General questions
  3. [SOLVED]  SUM With Problems
This topic is locked
[SOLVED]

 SUM With Problems

 		12/4/2015 07:42:09
ASPRunnerPro General questions
R
 Ramonxxd author

Hi

I have problems in my calculations, someone help me?
This is the code in ASPRunner

SELECT

ID,

[data],

titulardaconta,

nomedofalecido,

localdocorpo,

estado,

cidade,

telefone,

possuijazigo,

sepulturasera,

funeralcheckbox,

funeralpreco,

urnabox,

urnapreco,

remocaobox,

remocaopreco,

veubox,

veupreco,

locacaobox,

locacaopreco,

prepdocorpobox,

prepdocorpopreco,

jogosbox,

jogospreco,

documentacaobox,

documentacaopreco,

sepultamentobox,

sepultamentopreco,

veloriobox,

veloriopreco,

coroadefloresbox,

coroadeflorespreco,

onamentosbox,

ornamentospreco,

velasbox,

velaspreco,

embalsamentobox,

embalsamentopreco,

livropresencabox,

livropresencapreco,

agentesocialbox,

agentesocialpreco,

transterrestrebox,

transterrestrepreco,

valordacontratacao,

autorizadopor,

para,

funeralpreco + urnapreco + remocaopreco + veupreco + locacaopreco + prepdocorpopreco + jogospreco + documentacaopreco + sepultamentopreco + veloriopreco + coroadeflorespreco + ornamentospreco + velaspreco + embalsamentopreco + livropresencapreco + agentesocialpreco + transterrestrepreco AS total

FROM autorizacaosuda


And here the exemples in Images




Thanks and see you later. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=23519&image=3&table=forumtopics' class='bbc_emoticon' alt='B)' />
Sergey Kornilov admin 12/4/2015

What is the question?
R
 		Ramonxxd author 12/4/2015



What is the question?



SUM not calculated my cents correct price is 1551,05.
Sergey Kornilov admin 12/4/2015

When you enter decimal data you need to enter it as 50.25 and not as 50,25. Give it a try and let me know.
R
 		Ramonxxd author 12/7/2015



When you enter decimal data you need to enter it as 50.25 and not as 50,25. Give it a try and let me know.


if I put exemple: 150.25 and more 150.25 is the results.


help me please.
EDITED
I resolve the problem change in DB, to Currency. Its Work <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=78384&image=2&table=forumreplies' class='bbc_emoticon' alt=';)' />