This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Any way to reference just the quantity fields on the two lines into the result as 1 line? dont want sum or difference just the numbers in separate columns.

<https://blog.prolecto.com/2014/05/16/reveal-both-aggregate-and-detail-in-netsuite-saved-search/|https://blog.prolecto.com/2014/05/16/reveal-both-aggregate-and-detail-in-netsuite-saved-search/>

Personally I prefer LISTAGG over NS_CONCAT (it's an officially documented function and more powerful, e.g. custom delimiter) but the theory is the same

thank you <@U29QCJQF3> let me try this and i will let you know the results :slightly_smiling_face:

<@U29QCJQF3> not having a luck with either concat or listagg. is there any available documentation that will give me a better idea on how to do this?

<https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm|https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm> this is the official document

getting somewhere :slightly_smiling_face:
is it possible to break the results into two different columns?