SUM problem with multiplier

[desperateUser]

This is making me nuts.

SELECT SUM(r.entry_amt)+SUM(r.entry_amt*.035) AS AMOUNT

I can select SUM(r.entry_amt) and get the right result. I can select SUM(r.entry_amt*.035) and get the right result but I can't add them as in the statement above.

What gives?!?

Penelope

 

[AlexCuse]

why not

select sum(r.entry_amt) * 1.35 as AMOUNT

Hope it helps,

Alex


[small]----signature below----[/small]
I can't compete with you physically, and you're no match for my brains.
You're that smart?
Let me put it this way. Have you ever heard of Plato, Aristotle, Socrates?
Yes.
Morons!

 

[ESquared]

What error do you get? I see nothing wrong with

SELECT SUM(r.entry_amt)+SUM(r.entry_amt*.035) AS AMOUNT

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]

 

[desperateUser]

All I get is the sum of r.entry_amt, the calculation doesn't happen. There is no error message.

 

[rajeevnandanmishra]

Can you put the result of following query here:

SELECT SUM(r.entry_amt), SUM(r.entry_amt*.035), SUM(r.entry_amt)+SUM(r.entry_amt*.035) AS AMOUNT

May be this helps in getting the cause of error.

 

[desperateUser]

Well, it seems to work but I need to remember what I was doing when it didn't! Thank you, can I reserve the right to revisit this if necessary?