Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Percent formula Field for CoGS
I have a formula field that calculates the cost of goods sold percentage for each item.
The basic formula is this:
{cost}/{pricelevel1}
For all items whose price is below $1,000 this formula works.
For all items whose price is $1,000 or over this fails with an invalid expression.
I believe it is the comma in the price that breaks the formula. I have tried using TO_CHAR, TO_NUMBER, NANVL, CAST, REPLACE and meny other techniques.
None have solved this issue. How do I remove the comma so that the division works?
0