# TSQL - Amount * 10% AS PercentOfAmount

Hi Experts,

I have this field:
[Amount]

I am looking for the correct syntax to do a percentage of the [Amount] so something like:
Select
[Amount],
Percent([Amount], * .10) As PercentOfAmount
From TableName

I know this is not correct and that is why I am posting:
Percent([Amount], * .10) As PercentOfAmount

###### Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Just multiply the field by the percentage.  Try:
``````Select
[Amount], ([Amount] * .10) As PercentOfAmount
From TableName
``````
https://msdn.microsoft.com/en-us/library/ms176019.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Microsoft SQL Server Data DudeCommented:
So, just multiply the number times .10 for ten percent, or is there any numerator / denominator expression that needs to happen?
Author Commented:
Thanks.

so I have this:
``````Select
[Amount], ([Amount] * .10) As PercentOfAmount
From TableName
``````

I forgot to include one other thing:
I need it to be rounded up to the nearest dollar.

Author Commented:
So I will also need to round

Example:
1525
using:
([Amount] * .10)
gives me:
152.50
I tried:
Round(([Amount] * .10), 2)

but I still get
152.5

I need it to:
153