Comment on page
Blank values
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
blank helper variable in if statements, for example, if an employee has no end date. 
Last modified 8mo ago