Comment on page
formerly known as "none"
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).
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.
You can also the
blankhelper variable in if statements, for example, if an employee has no end date.