title: Calculate net amount after discount in formula
body: <p>I need to put value in calculated column in SQL Server.</p>
  
  <p>The formula will need to be something like: col1 * 0.col2 (both columns 1&amp;2 can be null). 
  Col1 is the GrossAmount(decimal(10,2) and Col2(smallint) is the percent discount. </p>
  
  <p>I tried to search for a solution on this, but found nothing helpful so far. Any idea where I might find a good solution for this?</p>