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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Calculating Percentages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-18 : 19:02:10
Paula writes "I would normally calculate a percentage by dividing a number by the total then multiply by 100, i.e. (total / grandtotal)* 100.

However, when I try this same formula in sql I keep getting 0. What am I doing wrong? Thanks for your help!"
   

- Advertisement -