PBCS: How To Show The Result Of Division By Zero in Web Form and Smart View
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.
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:
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