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.
Report conditional formula
In a report like the screenshot:
1) how can I have a Formula field that shows negative Units (-500 not 500) if sales is less than zero: If (Sales<0) Units * -1;
2) Can I do this without having Units field in the report?
I think I can only do this in a saved search, maybe, but I'm not sure how to know about reports without asking. The 'Add Formula Field' seems to offer only limited formulas.
0