How does Arcade handle nulls?
Examples:
Is there anything else about nulls that we should be aware of?
Thanks.
Null values are basically handled like zero (or "" for strings), though I'm trying to get that changed.
Console("1 + null = " + (1 + null))
Console("'foo' + null = " + ('foo' + null))
Console("null == null = " + (null == null))
Console("null != null = " + (null != null))
Console("\nOther stuff:")
Console("Abs(null) = " + Abs(null))
Console("Min([null, 1, 2]) = " + Min([null, 1, 2]))
1 + null = 1 'foo' + null = foo null == null = true null != null = false Other stuff: Abs(null) = 0 Min([null, 1, 2]) = 0
How does aggregating on nulls work? If there are nulls in the "flag_1" field, will they be included in the average's count?
If you aggregate on a feature set, nulls will be filtered out (at least for Min). For arrays, You have to do it yourself.