PBCS: How To Show The Result Of Division By Zero in Web Form and Smart View

(Doc ID 2198739.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 16.10.47 and later
Information in this document applies to any platform.

Goal

When we define a formula column and define the formula as division like [B]/[A].

When the divisor (in this case column A) is 0, the formula column is shown as #error in PBCS, but it is shown as 0 in Smart View.  This document is to show how to show the result of division by 0 similarly in a web form and Smart View.

The following is an example:

1. Create a web form with a formula column and define the formula as division:



2. Open the web form in PBCS and you will find that division by 0 is shown as #error:

3. Open the web form in Smart View and you will find that division by 0 is shown as 0:

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms