SQL Sum

[gary1975]

Hi

I am trying to add a few coloums, but I continually get the answer of zero. I think it is happening because all the coloums I am using are integers. This is my formula which is part of a sql statement:

((Sum(york1.T20C156) + Sum(york1.T20C157)) / (Sum(york1.T20C155)))*100 AS varOwnerOcc

This is how would look with the numbers:

((38 + 30) / (83))*100 AS varOwnerOcc

Thanks

Gary

 

[hmckillop]

I would guess that as the values being divided are integers you are getting the rounded value.
Try converting them to decimals first and then execute

i.e.

SELECT ((convert(decimal(19,4),38) + convert(decimal(19,4),30)) / convert(decimal(19,4),83))* convert(decimal(19,4),100)

"I'm living so far beyond my income that we may almost be said to be living apart

 

[hmckillop]

sorry your statement should be :

SELECT ((Sum(convert(decimal(19,4),york1.T20C156)) + Sum(convert(decimal(19,4),york1.T20C157))) / (Sum(convert(decimal(19,4),york1.T20C155))))*100.00 AS varOwnerOcc

"I'm living so far beyond my income that we may almost be said to be living apart

 

[gary1975]

Thank you