How to add add row number to NetSuite saved searches

Question

I have a Transactions saved search that sums an amount over a number of grouped fields:

Results window looks like this (left out a number of Groups for simplicity) :

I would like to add a row_number to the result, such that the search result is ordered by a column that will always give the same ordering.

Is this possible?

I tried this, but the rownum column is not shown in the result :

@ehcanadian, I also tried this : and this

but then it just doesn't show that column in the preview.

Answer 1

Try using the rownum without the braces in your formula..

Answer 2

If you use at least one Summary column, Netsuite will not display any column without Summary Type defined, so you need to add that to your Rownum column too. So here is a working example:

And the result is:

Answer 3

Try the formula numeric {rownum}.