Submit Numeric Zero as Replacement for Missing Values in Smart View (Mac and Browser)

With the new Submit Zero option, you can choose to submit numeric zero values in place of #Missing label.

In Smart View Options, you can enter #NumericZero as a value for replacing missing data values with zeros (0). With #NumericZero, you can use functions but cannot submit zeros to the database. With the new Submit Zero option enabled, cells with the #NumericZero label are considered as actual zero (0) value for calculations and are submitted to the database correctly.

To enable submitting zeros as replacement for missing values:

  1. Open the Smart View Option panel, and then go to the Data Options tab.
  2. Under Replacement, enter #NumericZero in the #Missing/NoData Label field.
  3. Select the Submit Zero check box.

Business Benefit: The new Submit Zero check box enables you to submit zero as a replacement for missing values to the database for calculations.

Steps to Enable

To use the Submit Zero option, Service Administrators deploy a new or reuse an existing Smart View (Mac and Browser) manifest file.

To deploy a new or existing manifest file:

  1. Create a new manifest file or reuse an existing manifest file.
  2. In the Create Manifest File page, make any other selections and modifications, as you require.
  3. Deploy the manifest file to Smart View (Mac and Browser) users.

Key Resources

  • Working with Oracle Smart View for Office (Mac and Browser)