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

image.png

Why am i getting an error that im dividing by 0 when i have a case statement thats checking that

you put the nvl in the wrong place if you are trying to prevent division by 0

you divide quantityavailable by the result of your nvl

which can be one of 2 possible values, one of which is 0

thats not the level of analysis being done

/nullif(NVL({custitem_quantity_sold_amazon_30},0),0)

i did this and it fixed it.
forgot nullif