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

Please fix this formula and also add a NULLIF(&lt;denominator&gt;,0
CASE WHEN {amountunbilled} / {amount} &lt; 0.1 THEN Yes    ELSE No END

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations, the formula you provided can be fixed by adding a NULLIF function to avoid division by zero errors. The NULLIF function returns a null value if the two specified expressions are equal. Here, we use it to return null if the denominator is zero, thus avoiding a division by zero error.

The corrected formula would be:

```CASE WHEN {amountunbilled} / NULLIF({amount}, 0) &lt; 0.1 THEN 'Yes' ELSE 'No' END```

Please note that 'Yes' and 'No' are enclosed in quotes as they are string values. 

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C29J1BPM3/p1683208589336439|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.856662691

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1570113699497000|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.849497616

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1579815578027400|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.842535079



Please provide your feedback on this answer.