This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there no standard deviation function in suiteql?

nope <https://netsuite.custhelp.com/app/answers/detail/a_id/91857/kw/unsupported>

SuiteQL uses SQL-92.  It’s ancient and sucky.

Darn thats surprising it supports covariance but not standard deviation. I managed to calculate it with nested subqueries but thats a bummer.

well at least I just tested it and it doesn’t seem to work for me

throws `UNSUPPORTED SEARCH` and is not listed in the link above

I tried a bunch of things and couldn’t get it either

The cryptic “unsupported search” errors don’t help either.

“we’ve tried nothing and we’re all out of ideas”