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.
Formula to calculate markup % from custom cost field to base price field
How do I write a formula that shows what our item mark up is from the custom bom cost field (field ID: custitem7) to our base price? How we calculate outside of Netsuite using the 2 number highlighted in the example would be:
=100%-(5208.33/8608.00)
The result is 39% (with rounding)
0