PBCS: How To Show The Result Of Division By Zero in Web Form and Smart View
(Doc ID 2198739.1)
Last updated on JULY 19, 2022
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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document