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

I want to create a field that divides projected value by quantity to build with a formula..I thought it was {filed1} / {field2} but its not showing anything. It has taken some time to get to this point so I guess I'm wondering what I need to check on from this point. I have the type set to decimal on the field I created. Wondering if I need to change the display type maybe? TIA

Can you add projected value to a saved search?

That field might be scripted so not available in formulas

and then what would i do with the saved search?

I am having trouble even find the projected value field:facepalm:

Oh sorry. This was my “test”. If you can’t find it in a saved search then it’s probably not able to be used in a formula

What’s the field id id you click on the field label

fieldID for projected value is total and Quantity to build is quantity

Can you add a formula numeric to a saved search and the formula is just the {total} field

Can't find a record type that I can find {totals} in and it pop up