How do you calculate the difference between two columns in a summarized saved search. For example, if you had one column that showed the number of items on pending estimates and unapproved orders and another that showed the number of items on order, how could you determine whether you would run out? There are three methods:
1. Export to excel or have excel link to the csv version of the search as a datasource. You will usually need a macro however.
2. Create a suitelet or portlet to process the data and add the calculations.
3. Add scripting to the search itself. A text formula field can hold any value, including JavaScript. You can use this to embed a script that runs when the page loads and performs math on the results.
- Posted using BlogPress from my iPhone
Thursday, October 29, 2009
Subscribe to:
Posts (Atom)
