<div>
Hello vsllc,<br />
<br />
<br />
case when quantity &gt;o then cast((rate/quantity) as numeric (9,2)) &nbsp; &nbsp;else 0 &nbsp;end PerRate<br />
<br />
<br />
GOD BLESS,<br />
<br />
Aneesh R.
</div>


Hello vsllc,


case when quantity >o then cast((rate/quantity) as numeric (9,2))    else 0  end PerRate


GOD BLESS,

Aneesh R.

<div>
<div class="content wysiwyg-content">
I'm using the following formula to create a new column and I'm getting an error message that says 'Divide by zero error encountered'. &nbsp;How do i fix this?<br />
<br />
cast((rate/quantity) as numeric (9,2)) PerRate<br />
<br />
Thanks.
</div>
</div>


I'm using the following formula to create a new column and I'm getting an error message that says 'Divide by zero error encountered'.  How do i fix this?

cast((rate/quantity) as numeric (9,2)) PerRate

Thanks.

How do I fix divide by zero error message?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.