Blank Columns in saved search formula results

Instead of zero, the saved search formula results in blank column values.

This occurs because there may be null/blank values for any field used in the formula. The null/blank field values, when used in a formula result in null. This can be prevented by using the NVL function to replace null values with a quantity of 0.

Leave a comment

Your email address will not be published. Required fields are marked *