zero_flag

/*
if <value> is NULL:
    return 0
else:
    return <value>
*/

{% macro zero_flag(column_name) %}
    case when {{ column_name }} is null then 0 else {{ column_name }} end
{% endmacro %}