Saved Search Formula
Looking for resources/examples to create a saved search which pulls the current QTD, Prior Quarter, etc for last 5 quarters. Anyone have good examples of formulas or a sequel resource
Note – I don’t understand SQL but get the concepts of case when etc
This SuiteAnswers article:
SQL Expressions
Published 03/04/2011 12:24 PM | Updated 09/16/2019 10:37 AM | Answer Id: 10101
Also, the Database SQL Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/toc.htm (You can also just google for the specific function you’re looking for and the specific page you want from this is usually one of the top few results). Not all of the functions in here are guaranteed to work in NetSuite, so the SA article is the best to stick to if you can make those work, but most of these do work, so if you’re really finding the SA choices limiting, this is a good reference.
For specific examples, I would search SuiteAnswers for what you’re looking for using “saved search formula” keywords.
This was a great search I found with month and year comparison. Edit to your need I guess and it can potentially help you fill in the information you need.
Answer Id: 81594
https://netsuite.custhelp.com/app/answers/detail/a_id/81594/kw/sales%20by%20month%20search
