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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Like in a saved search formula
Ok so here is what im trying to do and wondering if im going down the right path.
I have a report that pulls in a list of all transactions that has a line item that contains the name "TR-APT-" or "TR-SS-". Which works great gives me 16 transaction numbers but should only have 12
So there are 4 transactions that have more than just either a TR-APT or TR-SS item attached and i would like only to see those that have just either item.
I am trying to use DECODE to see if the number of items with a TR-APT or TR-SS matches the number of total items in the transaction. I am looking at the correct function to use or am i way off.
0