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

can I use CASE WHEN inside of a mathmatical formula to pull a number. e.g. {itemordered}-(case when {onhand}&gt;{backordered} then {onhand} ELSE 0 END)

Yeah I don't see why not, you can try doing in SuiteAnalytics; it validates formulas for you.

i tried it and got an invalid expression error

Ok it usually tells you what is wrong with your expression.

For example, this doesnt work bc wrong output type, change to float and it validates

sorry I am still pretty new to NS; is Suiteanalytics free?

there's a tab at the top of netsuite called SuiteAnalytics

i dont know how to test a formula in it though like you did

Create a formula column (its at the top of the fields list), and then just hit Validate on it in the box