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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
dense_rank help
I have a saved search where I need to know the "order" of POs according to date.
So if I have 5 POs as so:
PO0001 ItemA 1/1/2009
PO0003 Item B 2/1/2009
PO0002 ItemA 3/1/2009
PO0004 ItemA 4/1/2009
PO0005 ItemB 5/1/2009
I want to know what the rank of each PO per item is based on date.
So in my example, the result would be
PO0001 ItemA 1/1/2009 ->rank 1
PO0003 Item B 2/1/2009 ->rank 1
PO0002 ItemA 3/1/2009 ->rank 2
PO0004 ItemA 4/1/2009 ->rank3
PO0005 ItemB 5/1/2009 ->rank 2
So using dense_rank() should be able to tell me. And in fact, I have it working if I do
0