Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Search {Mainline} Formula
Hi Everyone,
I'm trying to get a saved search to give me only the mainline of transactions, but I do not want to use the out of the box Mainline * I want to use my own formula numeric and report if the value is equal to 1. This is for a tricky save search I want to make.
Here is my formula that's not working
case when {mainline}= 'Y' then 1 else 0 end
Formula numeric = 1
When I run this query I get both the main and nonmain lines
Can any suggest how I can get only the main line???