title: Teradata - Numeric overflow occurred during computation
body: <p>I am having an issue with a calculation in one of my Teradata queries.  I am multiplying two numbers by each other but i am getting a "Numeric overflow occurred during computation." error when running the query.  I ran a type on both fields and they are DECIMAL(18,15) and DECIMAL(18,9).  I tried casting them both to DECIMAL(18,18) when i do the division but its still throwing errors.  Here is the calculation. UNITS is the 18,15 and PRICE is the 18,9. Can anyone please give me any tips on how to resolve this?</p>
  
  <pre><code>cast(UNITS as DECIMAL(18,18))* cast(PRICE as DECIMAL(18,18)) as  NEW_CALC
  </code></pre>
  
  <p>Thanks,</p>
  
  <p>Craig</p>