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

Rookie Asked on October 29, 2019 in Saved Searches.
Add Comment
2 Answer(s)

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.
Beginner Answered on October 29, 2019.
Add Comment

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

Beginner Answered on October 29, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor