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.
Margin
Hi,
We got a report saved for items that show Margins, and we are using this formula : ({onlineprice}-{cost})/NULLIF({onlineprice},0)
what I am trying to do is get rid of any items that are less then 30% I cannot find formula (percent) under criteria. I tried under the formula numeric field with the same formula and used equal or greater than but it is not bringing anything up. Please could someone help me?
Thanks
0