Skip to Content
0
Former Member
May 11, 2007 at 01:45 PM

Adding values to "null" query results

13 Views

We have a query that returns some data in the key figures but in some cases, no records are selected and that result cell is NULL and not 0. Is there a way to force BW to put a zero in those result rows even if there is no data? The "Dispaly Zeros" setting on the query is already turned on. I'm not suppressing anything in the definition, but they still don't show up.

EX:

.............KF1...........KF2..............KF3

A..........10.............. .............. 5

B.......... ............10................

I want to Show '0' in the blank spots.