null to a zero

building reports webintelligence
1

Hi All,

in boxi rel 3.1 is there a webi setting which turns numeric fields from nulls to zeros?

Thanks

Bell_33 (BOB member since 2010-07-05)

2

You can just use the standard cell formatting…it allows you to specify the format for positive, negative, zero and null…so put a 0 in the null box and off you go.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Nick, that has not worked, please can you outline the steps involved…Thanks

Bell_33 (BOB member since 2010-07-05)

4

Nick, works…
Cheers

undefined = null box

Cheers

Bell_33 (BOB member since 2010-07-05)

5

Not working for cross tables, though, which is very regrettable. BO is not very user-friendly here …

triangulum :switzerland: (BOB member since 2011-10-21)

6

Hi u can use this formula
=if(isnull([object]);0;[object])
i will solve ur problem very easily…

babu_272 :india: (BOB member since 2010-07-28)

7

Yeah but I would have to store the formulae in variables (since they are accessed once in the condition check and another time in the not-null case).
Since most of my formulae are now directly entered in the cells, I was looking for a more economic way.

Then I came across a hint from Estonia …

The cleanest solution would still be if the number formatting allowed to display “0” for null values in case of cross tables, too.

triangulum :switzerland: (BOB member since 2011-10-21)

8

In the crosstab cell, try:

0+[Measure / Formula]

HTH

mcnelson :uk: (BOB member since 2008-10-09)

9

It works for me in a crosstab in XI 3.1. I just created a custom format of 0;0;0;0

Debbie

Debbie :uk: (BOB member since 2005-03-01)