Using SuiteScript 2.1, create a search that enables 'Show Totals' to include totals for all numerical fields in search results

AI generated answer (using internal Slack threads):

In SuiteScript 2.1, you can create a search that enables 'Show Totals' to include totals for all numerical fields in search results. However, it's important to note that the 'Show Totals' option only works with non-summarized results. If you're working with summarized results, you'll need to manually calculate the totals in your script. Here's a basic example of how you can create a search and calculate the totals:

javascript
var searchObj = search.create({
   type: "transaction",
   filters:
   [
      ["amount","noneof","@NONE@"]
   ],
   columns:
   [
      search.createColumn({name: "amount", summary: "SUM"})
   ]
});
var totalAmount = 0;
searchObj.run().each(function(result){
   totalAmount += result.getValue({name: "amount", summary: "SUM"});
   return true;
});

In this example, we're creating a search on the 'transaction' record type, filtering out transactions where the 'amount' field is empty, and then summing up the 'amount' field. The total is then calculated by iterating over each result and adding the 'amount' to the 'totalAmount' variable. Remember, this is a simplified example and you may need to adjust it to fit your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******