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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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