The quick answer
Edit the saved search, open Results, and replace the nullable Quantity result with Formula (Numeric) using NVL({quantity},0). Keep the original Sum summary type and label, then Save & Run. Compare the same groups with the original results to confirm that only the missing quantity becomes zero.
A blank quantity may mean “nothing to report” in one search and “data we need to investigate” in another. This example is an existing transaction search grouped by Item. The team has agreed that a missing quantity in this report should display as zero. The person and operating-company names in the screenshots are fictional example data.
The walkthrough also changes an existing quantity-divided-by-12 result. Its Maximum summary picks the largest row calculation for each item. It does not divide the group's total quantity by twelve, and it is not an average.
Before you start
You need permission to see, edit, and run the saved search. A private or audience-restricted search may be absent from your list even if you can run other searches. Identify at least one qualifying group with a null quantity, one genuine zero, and one nonzero quantity before editing. Confirm that zero is the right interpretation for the null value. NVL does not create a group excluded by Criteria. This guide changes displayed search results; it does not edit transactions or source quantities.
The example uses a summary search named Item Quantity Review. Its result columns are Item grouped by Group, Quantity summarized by Sum, and a second numeric formula summarized by Maximum with Round to Tenths. Preserve the search's Criteria, grouping, sort order, and any other results that your own report needs. In a transaction search, check the existing line filters, such as Main Line, Shipping Line, or Tax Line, before treating a quantity as an item quantity. Also check the transaction types, units, and whether negative quantities from returns belong in the report. Labels and controls may vary by role and account.
01. Compare the original rows
Open Lists > Search > Saved Searches, find Item Quantity Review, and choose View. Note the result count and the same item groups you will check after the edit. In this example, Freight Allowance has a blank Total Quantity, Cable Sleeve has a genuine zero, and Desk Bracket and Sample Insert have positive quantities. There are four groups.
02. Inspect the Results settings
Click Edit this Search, then open Results. Check the existing rows before changing them. Item uses Group. Quantity uses Sum and the label Total Quantity. The second result uses Formula (Numeric), Maximum, Round to Tenths, and the existing expression {quantity}/12. Leave Criteria untouched.
03. Replace the Quantity result
Select the Quantity row and change Field to Formula (Numeric). Open the formula editor, enter NVL({quantity},0) without quotation marks, and click Set. NVL returns the quantity when it exists and zero when the expression is null. The walkthrough changes the existing row in place; if your form cannot do that, add a numeric formula result with the same summary settings and remove the obsolete Quantity result only after comparing the configuration.
04. Keep Sum and the label
Before committing the row, check Summary Type = Sum and Summary Label = Total Quantity. Click OK. The committed row should show Formula (Numeric), Sum, and NVL({quantity},0) together.
05. Update the second formula
Select the existing quantity-divided-by-12 result. Replace {quantity}/12 with NVL({quantity}/12,0), then click Set. Keep Maximum and Round to Tenths. Set the summary label to Maximum Monthly Row Quantity and commit the row with OK.
Twelve is a fixed, nonzero denominator here. Do not copy this pattern into a variable-denominator calculation without dealing with a possible zero denominator separately.
06. Save and compare
Click Save & Run to save the revised definition and execute it. Compare the same four groups with the baseline, and recheck the search title, Criteria, grouping, sorting, and other result columns. Freight Allowance now shows 0.00 where Total Quantity was blank. Cable Sleeve still shows zero; Desk Bracket remains 6.00 and Sample Insert remains 4.00. The result count remains four.
The Maximum Monthly Row Quantity column also shows 0.00 for the missing row and 0.30 for the positive examples. Desk Bracket's total of six comes from source quantities of four and two; the Maximum value uses the larger row calculation, four divided by twelve, rounded to tenths. The label is inherited from the search; it does not turn the result into a monthly average or the group's total divided by twelve.
If a blank remains, inspect which result column produced it. A missing join, text result, or unrelated calculation may need a different fix. The captured example verifies the displayed search result and its saved configuration; production formula execution was not tested in the source account.
Common questions
Why did a blank quantity become zero?
The result now uses NVL({quantity},0). When Quantity is null on a qualifying source row, the formula returns zero. It leaves a real zero or nonzero quantity alone.
Why does Desk Bracket show 6.00 in Total Quantity but 0.30 in the other column?
The total sums source quantities of four and two. The Maximum result takes the larger row-level calculation, four divided by twelve, then rounds it to tenths. It does not divide the total of six by twelve.
Does NVL add an item group that the search criteria excluded?
No. It changes a null result on a qualifying row. If Criteria or a join excludes all rows for an item, the formula cannot bring that item into the results.
Does this edit change the transaction quantity?
No. It changes how the saved search displays a result. The source transaction quantities remain as they were.
Can I use the same formula when the denominator might be zero?
Not without another guard. This example divides by the fixed number twelve. If the denominator comes from a field and can be zero or null, handle that case explicitly before dividing.