11G BI Publisher: NULL Values On Line Graph Are Shown As 0 Instead Of NULL

(Doc ID 1579476.1)

Last updated on OCTOBER 04, 2016

Applies to:

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


When creating a graph in Answers then it ignores NULL values and is displayed correctly.

When the same graph is recreated in BI Publisher Layout Editor additional formula is added (default: Summation) and it is not possible to select "No Formula".

This changes the NULL values to 0 and then makes the graph incorrect


 upgrade to BIP or BIP


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