Blank values

How are blank values treated in Causal?

Blank values are treated like 0s in most formulas (e.g. blank + 7 = 0 + 7 = 7), except in instances involving a set of numbers (e.g. avg, min/max/median, count etc) where blanks will be excluded (e.g. avg(5,10,blank) = avg(5,10) = 7.5).

Blanks in Data

If you have blank values in data, Causal will treat them as 0 by default, unless you change the Blanks in Data setting to "Treat as blank". This is useful if you want to exclude the blank values in data from things like averages, min/max etc, as described in the section above.

Blank helper variable

You can also the blank helper variable in if statements, for example, if an employee has no end date.