Does anyone have any ideas on how to Sum only one field in a saved search? We are creating a report for inbound shipment quantities {quantityexpected}, which we need to sum, though we need to only deduct a single {quantitybackordered} quantity, not the sum of both. It appears that in Netsuite, rather than how sum works in Excel, it multiplies the entire sum for all fields, so therefore in our case the quantitybackordered is multiplied numerous times, given that the sum of {quantityexpected} spans numerous purchase orders. e.g. we sum {quantityexpected} together for four purchase orders, with 200 on backorder, yet when summing everything, rather than 200 on backorder we end up with a result of 800 on backorder, one {quantitybackordered} multiplied by each of the four purchase orders. The saved search we're needing is to create a Surplus/Deficit report using existing stock on hand minus the total quantity expected from inbound shipments, to ensure we're staying ahead of the curve for maintaining enough stock to meet demand. Any assistance with this would be appreciated.

use the formula SUM({quantityexpected}) - MAX({quantitybackordered}) Use the summary type of Maximum

@Christian Bannard if above sol'n does not work consider CloudExtend Excel. iI this is a search you run regularly and you want to see it in Excel and then use Excel formulas it might be a good fit. You can put one or more searches on a schedule or re-run them on demand directly from Excel so that any analytics you perform on the data set are updated immediately.

Worked beautifully, thankyou @AI1