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!
WEIRD ISSUE with Saved Searches
So what I have is a search (Customer search) that has 2 field in the Criteria (Inactive and status), and just a few standard field in the Results field, when I run this search I get 52,000 results that is what I expect... Now if I add a formula "Case when {purchaseditem.parent}= 'Software' Then 'AD' end" the total is reduced to 17,000.
Can anyone explain what is happening here? Is this normal? Why would a formula field in the Results reduce the total records reported? Is there something wrong in my formula that is causing this issue?
Thanks for any Help.
Tom