cancel
Showing results for 
Search instead for 
Did you mean: 

NULL-Values in Chart key figure - how to don't display an entry

Former Member
0 Kudos

Hello,

I've a big problem with Crystal 4 Enterprise. I retrieve the data from our BW 7.4 from a query with i.e. one characteristic and two key figures. The first key figure is the current value and the second one is a manually prognosis. No the problem is, that there could be for one row no valid prognosis. In the key figure this is show by a value < 0. As example I get this data from my query:

PrognosisCurrent
Jan2545
Feb3645
Mar2269
Apr-185
May7163
Jun7855
Jul-165
Aug10

28

This is interpreted, because lower zero means no prognosis.

PrognosisCurrent
Jan2545
Feb3645
Mar2269
Apr85
May7163
Jun7855
Jul65
Aug1028

The expected result is now a line chart where the "empty" rows of this series are skipped. But how can I do that in CR4E?

View Entire Topic
Uli_Stoeckl
Participant
0 Kudos

Hi Gerrit,

please take a look in this doc:

If the link does not work, it is also in the note: 1214853 - How to display null values in a line chart

Bye

Uli