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

I’m also interested in if this works. Being able to break up formulas into multiple columns would be very beneficial.

This did not work and I drop it because is not officially supported but break stuff into columns is something you can do with LISTAGG let me find an example…

<@U2ED4NDEK> I can’t find the example I use to have working with that but I know for sure LISTAGG works well in NetSuite…

I did play with this a bit, got one to work `LISTAGG({number}) WITHIN GROUP (ORDER BY {amount})` on a transaction search with a text formula set to minimum summary type. I’d be curious to know what a practical application to this would be. It seemed like no matter what I changed the ORDER BY field to I always got the {number} field in return.

Realistically I was looking for something where I could put a formula in one column and then reference the result of that formula in a formula in the following column, much like you would do in an excel document.