Does anyone know how to do advanced math in Netsuite like taking a set of data points - monthly sales from IFFs of an item, and using that to perform a standard deviation? I can do the analysis in formulas in Excel but because I can pull the data set down and reference a row worth of data and Excel can sequence it (which is important to determine 25% and 75% to do the standard deviation on that data).

I haven't tried but there is a

STDDEV

oracle function you may be able to use in a saved search

hmm, how could I run this oracle function in a saved search? I've never used any functions outside of the few available in the Netsuite drop downs in the saved search formula fields

You would use a formula numeric column, e.g.

STDDEV({fieldname})

To do standard deviation you have to bring in a bunch of data points though - like 12 months worth of quantities, broken down by month, it's not just STDDEV({quantity}) it's like take all the quantities, add them up by month, then take that array of 12 numbers and do a standard deviation of those 12 data points

Try grouping the search by month

The formula would still be running on that particular month's row - wouldn't work as far as I can tell

Ah then maybe the analytic version would work

Yeah I've never messed with SuiteAnalytics, going to try tomorrow, let me know if you have seen any good tutorials on it

To be clear I meant the analytic version of STDDEV but was still thinking about using a saved search

Just gives ERROR: Invalid Expression