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.
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