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!
Saved Search Formula Column / Field Reference in Other Formulas...
We are trying to produce a number of reports that are usually easy if we could create a variable in our search. Normally, in SQL, we will write something like:
SELECT (amount-discount) AS netofdiscount from transaction where transactionID = 123
In this case, I can use 'netofdiscount' as an alias or reference to other parts of my query.
When writing a Saved Search with a formula column, we want to name the formula column so we can reference it again from another column. In the example, it would be powerful to reference it as {netofdiscount}. Perhaps there is can be a way to produce a JavaScript variable in the column reference as well...?
0