Calculation Not Displaying Proper Answer I am sure this results from an incorrect parenthesis on my part or something silly like such, but for the life of me I can not get this syntax accurate.  Here is sample DDL

Declare @Hold Table
(
val1 float
,val2 float
,val3 float
,val4 float
,val5 float
,val6 float
,val7 float
)

 Insert Into @Hold values
 (145, 10, 20, 30, 40, 50, 60)

 Select
 (val1-(val2+val3+val4+val5+val6+(val7*.22)))/val1
 FROM @Hold 


So for a breakdown of what I am after with the equation:

val1 = 145
val2+val3+val4+val5+val6 = 150
val7 = 60
val7 * .22 = 13


Which takes us to this equation:

145-(150)+13/145
8/145


My desired output is
.055172 or 6%

However my code above produces this as the answer:

-0.12551724137931


What do I need to alter in order to get my above %?
In addition to correcting the parentheses, if you want your output to be .055172 then you should cast (val7*.22) as an integer in your equation.

http://rextester.com/SQP94408

Declare @Hold Table (val1 float,val2 float,val3 float,val4 float,val5 float,val6 float,val7 float)
Insert Into @Hold values (145, 10, 20, 30, 40, 50, 60)
Select
 ( 
   (val1)
  -(val2+val3+val4+val5+val6)
  + (cast((val7*.22) as int)) -- this results in 13
  )  /val1
FROM @Hold 
/* results in 0.0551724137931034 */

Select
 ( 
   (val1)
  -(val2+val3+val4+val5+val6)
  +(val7*.22)  -- this results in 13.20 not 13
  )  /val1
FROM @Hold 

/* results in 0.056551724137931 */