title: Arithmetic overflow error converting float error in sql
body: <p>I am getting this error </p>
  
  <blockquote>
    <p>Arithmetic overflow error converting float to data type numeric</p>
  </blockquote>
  
  <p>when I try to run my view but not sure what am I doing wrong with my calculation. I have researched but could not solve it so far. </p>
  
  <p>Here is the line of code that is causing the error:</p>
  
  <pre><code>ISNULL(CAST(CAST(TOTAL_APPTS.APPT_CNT AS FLOAT) / TOTAL_RECS.PAT_CNT AS NUMERIC(3, 2)), 0) AS [CONVERSION RATE]
  </code></pre>