Home
Products
Services
Knowledge base
About
Contact
Sign in
Search
Articles
Inspiration
Docs
Questions
Feature Requests
Issues/ Bugs
Other
Knowledge base
Documentation
Report Builder
Syntax Reference
avg
in
strreplace
col
null (missing)
number
boolean
string
scalar
vector
and
or
Equivalency
avg
countin
countinrange
filter
ifnull
inrange
mean
median
nullifeq
nulliffalse
nulliftrue
pctin
pctinrange
round
sum
validcount
Notes
avg
0
0
Edited Sep 1, 2015
Alias: mean
Usage:
[number]
x
←
avg(
[vector]
y
)
Computes the average of the non-
null
values in the
vector
. Returns a
number
.
NOTE: [PERFORMS TABLE SCAN]
Example:
avg(Q1)
Leave a Comment
Please
sign in
to leave a comment.