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!
Financial Analysis - Monthly Sales to Monthly Support Cases
I need to create a saved search that will include what I think is pretty basic stuff but I'm stuck. I can pull Sum and Counts with no issue in two separate saved searches but I need to find a way to merge them into one. This will let us see who the high % support requesters are in our client base with respect to sales. Piece of cake.
Criteria:
Active customers with transactions (Cash Sale + Invoice) where date is within last month.
Results:
Customer
Sum of Last Month's Transactions
Count of Last Month's Closed Cases
Example:
ABC Company
$50.00
550