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

Hello everyone, I created a custom formula for a saved search, but the results aren't what I expected. Could anyone help me troubleshoot this?

It looks like you're trying to divide the amount by the quantity

and the amount may be zero depending on the memo string.

I guess the string comparison could be true multiple times which means you're adding multiple amounts together before dividing?