Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tariq2
Posting Yak Master
125 Posts |
 Posted - 2010-09-28 : 08:57:44
|
| (RC)/GT*100 as ReportPercentThe above line is meant to be calculating percentages but producing zeros.this is perhaps an integer issue: integer dividing integer.I have tried CAST and FLOAT but not quite working.Many thanks! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-09-28 : 09:06:04
|
| Try(RC)/GT*100.0 as ReportPercentHarsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
tariq2
Posting Yak Master
125 Posts |
Posted - 2010-09-28 : 09:19:30
|
| Harsh,Now I just get 0.00 as opposed to 0 |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-09-28 : 09:24:20
|
quote:
Originally posted by tariq2
Harsh,Now I just get 0.00 as opposed to 0
(RC)*1.0/GT*100.0 as ReportPercentPBUH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
tariq2
Posting Yak Master
125 Posts |
Posted - 2010-09-28 : 09:46:38
|
| Thank you guys, works a treat :) |
|
|
|
|
|
|
% calc producing zeroes