A new setting has been added that allows Nulls to be treated as zero within the derivation runtime: "Treat Nulls As Zero"



Prior to this setting, many derivation expressions had to use the IsNull(..) function to handle nulls properly. This new setting simplifies expressions by avoiding the IsNull(..) call.

If the dependent stream is a string, then "" is used. If it is a boolean, then false is used.

This new feature works in combination with LAST_VALUE. If this setting is engaged and there is no LAST_VALUE, then LAST_VALUE will be zero.