Percentage Calculation with two decimal digit rounded off

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

christine.dsouza Old Hand Points: 301 More actions · Answer 1

Try this...

SELECT TOP 10 DFS_Request_Received as trans

,ROUND(((DFS_Request_Received*100.0)

/(case Total.totalTrans when 0 then 1 else Total.totalTrans end)),2) as Percentage

FROM DFS,

(select sum(DFS_request_received) as totalTrans from DFS) Total

order by trans desc

Soundari SSC Eights! Points: 847 More actions · Answer 2

Hi

select (1*100)/9 which will give the result as 11

select (1*100.0)/9 which will give the result as 11.111111

select round(((1*100.0)/9),2) which will give the result as 11.110000

but i want the result as 11.11 only

How to remove the trailing zeros? Any suggestion?

HowardW One Orange Chip Points: 29109 More actions · Answer 3

One Orange Chip

Points: 29109

February 17, 2009 at 3:09 am

select cast(round(((1*100.0)/9),2) as decimal(5,2))

Soundari SSC Eights! Points: 847 More actions · Answer 4

SSC Eights!

Points: 847

February 17, 2009 at 3:16 am

Hi

Thank you. CAST function worked for me

Latha

Karthik Newbie Points: 2 More actions · Answer 5

Hi

select 100*(24698891)/39552506

i need answer 62.44

How can i reach the requirement? Any suggestion?

Thanks in advance

Jonathan AC Roberts SSCoach Points: 18398 More actions · Answer 6

Karthik wrote:

Hi select 100*(24698891)/39552506 i need answer 62.44 How can i reach the requirement? Any suggestion? Thanks in advance

select convert(decimal(9,2),100*(convert(decimal(15,4),24698891))/convert(decimal(15,4),39552506)) Percentage

Cookies on SQLServerCentral