This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know why I'm getting the divide by zero error with this formula?

'&lt;style&gt;.progress{overflow:hidden;height:18px;background-color:#ccc;border-radius:4px;-webkit-box-shadow:inset 0 1px 2px rgba(0,0,0,0.1);box-shadow:inset 0 1px 2px rgba(0,0,0,0.1)}.progress-bar{float:left;width:0;height:100%;font-size:11px;line-height:18px;color:#fff;text-align:center;background-color:#428bca;-webkit-box-shadow:inset 0 -1px 0 rgba(0,0,0,0.15);box-shadow:inset 0 -1px 0 rgba(0,0,0,0.15);-webkit-transition:width .6s ease;transition:width .6s ease}&lt;/style&gt;&lt;div class="progress"&gt;' || '&lt;div class="progress-bar" style="width:' || CASE WHEN ROUND({quantityshiprecv}/NULLIF({quantitybilled}*100, 1)) &gt;= 100.0 THEN 100 ELSE ROUND({quantityshiprecv}/NULLIF({quantitybilled}*100, 1)) END || '%;"&gt;  ' || ROUND({quantityshiprecv}/NULLIF({quantitybilled}*100, 1)) || '%&lt;/div&gt;&lt;/div&gt;'

if `quantitybilled` is zero then your entire denominator will be zero.

you might want `NULLIF({quantitybilled}*100,0)`?

I have tried it with a 0 instead of a 1 and it's the same result

If you are trying to make a progress bar, give this a shot:
```'&lt;style&gt;progress { height: 15px; text-align: center; font-size: 10px; background-color:red } progress:after { content: attr(value)"%"; } &lt;/style&gt;&lt;progress value="' || {field}*100 || '" max="100"&gt;'```

Note that my {field} has a max value of 1 so I am multiplying it by 100.

'&lt;style&gt;progress { height: 15px; text-align: center; font-size: 10px; background-color:red } progress:after { content: attr({quantityshiprecv})"%"; } &lt;/style&gt;&lt;progress value="' || {quantitybilled}*100 || '" max="100"&gt;'

This is what I used, but it does not show a bar that is less than full when the transaction is partially billed. It either shows 0% or 100%

not 100. You need to adjust the base code to make it work.

'&lt;style&gt;progress { height: 15px; text-align: center; font-size: 10px; background-color:red } progress:after { content: attr({quantityshiprecv})"%"; } &lt;/style&gt;&lt;progress value="' || {quantitybilled}*100 || '" max={quantityshiprecv}&gt;'

Other way. Max= quantity or {quantitybilled}

'&lt;style&gt;progress { height: 15px; text-align: center; font-size: 10px;} progress:after { content: attr(value)"%"; } &lt;/style&gt;&lt;progress value="' || ROUND(({quantitybilled}/{quantity})*100,2) || '" max="100"&gt;'