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,]