Functions on NULLs
If used in the arguments of aggregate functions such as
sum
/avg
/med
, NULL values are
ignored.
x = 1 2 NULL NULL 3;
log x;
// output
[0,0.693147,,,1.098612]
x = 1 2 NULL NULL 3;
avg x;
// output
2
sum x;
// output
6
med x;
// output
2
x=1..3;
move(x,3);
// output
[,,]
prev 1 2 3;
// output
[,1,2]
next 1 2 3;
// output
[2,3,]