Calculate median of values in various saved searches

Customer needs to calculate the median for the sales order quantities of his customers in order to determine mid-point of customer orders. To accomplish this in NetSuite, perform the following steps:

 

1. Use the formula:

median({XXX}) /* avg() */

2. Set the Summary type to Average

 

Ex.
amount of a = 1
amount of b = 5
amount of c = 2
amount of d = 8
amount of e = 7

Result: 5

 

Note: This is currently tagged as an Enhancement (192275: Reports>Saved Searches>All Saved Searches>New>Transactions>Results Tab: Summary Column: Function to compute for 'Median'). The solution provided is just a temporary fix and does not replace the supposed behavior of the system. Affected users are encouraged to call NetSuite Support should they encounter the same problem or if the temporary fix does not work for them.