We can execute the formula even if some columns are blank in Saved Search using the following:-
Navigate to
1. Lists > Search > Saved Search > New
2. Select the Type of the search
3. On the Results tab , Column Subtab;
Field – Formula Numeric
Formula : NVL({location on order},0
4. Save and Run