Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
DENSE_RANK to filter
I am trying to use `RANK` `DENSE_RANK` and `KEEP` aggregate SQL Expressions. I have a saved search that is looking at the SO. I want to pull in the first IF created off of the SO. I know can just `GROUP` the sales order and `MINIMUM` on the Fulfilling Receiving transaction, but because of some alternative factors I can't do it this way.
In the results of the search I am able to get the desired results. If you see the last column in the 'Results from running search' image, I use the `DENSE_RANK` function in order to rank which IF came in first. Now I want to use that formula in order to filter over the summary criteria of the search.
0