Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to 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...?