Scenarios for Rollup as null, Combine as zero
These scenarios are for formulas that have rollup numeric parameters. These parameters are defined with the Missing Values choice as 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. |