My Oracle Support Banner

OVR - BIPublisher 12.2.1.1 - Calculations Incorrect (Doc ID 2562880.1)

Last updated on OCTOBER 07, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle BI Publisher 12.2.1.1.0 (build# 20170913.0823 on Wed Sep 13 08:28:48 PDT 2017) version, Designing Layout Templates

ACTUAL BEHAVIOR
OVR - BIPublisher 12.2.1.1 - Calculations incorrect

EXPECTED BEHAVIOR
It should show correct calculation value not zero.

The issue can be reproduced at will with the following steps:

1. Create a report with two numeric columns. Edit the calculation for Column2 to below:

division(multiplication(Column1,’200000’),Column2)

2. Result in each row is correct. Edit the calculation for Column2 Total to below:

division(multiplication(summation(Column1),’200000’), summation(Column2))

Total displays as zero!

If you remove the calculation from the column, then the total calculation displays correctly, but cannot get both to work at the same time.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.