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

Is there any way to multiply columns on a saved search?

As far as having a column that is the result of multiplying other columns or values? You can have a field/column that is a formula

I'd like to add a new column that is these two columns multiplied

This should work: <https://stackoverflow.com/questions/51585866/netsuite-saved-search-formula-to-multiply-results-of-two-other-columns>

So essentially you are adding a new field with a numeric formula as the type. Then you'll have to specify the two other fields

NVL({averagecost}, 0) * NVL({quantityavailable}, 0) was the example given. I'll look in my system to see if can reproduce as well.

Yep, I did NVL({inventorydetail.itemcount}, 0) * NVL({custitem_actual_length}, 0)

That worked on my tables, let me know if throwing error.