Need Zero Numeric for blank Cell

[rickdunna]

I am trying to do a variance between two cells and the data in 1 object has undefined cells. I tried using the undefined setting in format cells, the formula stills does not reconize it as a numeric 0.

Business Objects 6.5

Thanks Rick

 

[blom0344]

Formatting is just that, you see zero's instead of nulls.
The best strategy is to avoid bringing in nulls by means of NVL/Coalesce functions in the dataprovider that transform nulls into zero's.
Other than that look into constructions like

=If Isnull(<variable>) then 0 else <variable>

to play with..

Ties Blom

 

[rickdunna]

Yep I tried the isnull, is " ", and a lot of other things, but it won't work.

The key is that the cell value is nothing. it does not exist as a row in the database. There are two data provider.

I would think though if it displays in the report there should be a way to do this.

Thanks Rick.

 

[blom0344]

Still, it should be possible to work around this limitation.
With 2 dataproviders you can still test for the Isnull occurence.
Example:

=If Isnull(<variableA>) then <variableB> else
<variableB> - <variableA>

In this example there is always an occurence of variableB whereas variableA can be null

Ties Blom