Scenarios for Material Rollup as null, Combine as zero

These scenarios are for formulas that have Material Rollup numeric parameters. These parameters are defined with the Missing Values choice as Material Rollup as null, Combine as zero.

Formula Scenarios Result
Formula has no ingredients. Formula has Null value for the parameter. Parameter value is not written to the database.
Formula has ingredients, all with null value for the parameter. Formula has Null value for the parameter. Parameter value is not written to the database.
Formula has ingredients, all have a non-null, non-zero value for the parameter. Formula has non-null value for the parameter.
Formula has ingredients, some have non-null, non-zero values. Others have null values. Formula has non-null value for the parameter.
Formula has ingredients, some with zero values, some with null values. Formula has zero as a value for the parameter.

Zero values are written to the database.