Prohlem with Null

[Raj321]

Hi all,
How to display '0' in palce of null values.

 

[blom0344]

Hello Koti,

Try:

If Isnull(<variable>) Then 0 Else <variable>

where <variable> is the measure you are evaluating

blom0344

 

[SIGBO]

Koti,

Two other ways around the problem :

In Report Writer you can select the cell or column, select Format Cell, select Number and enter 0 in the Undefined box.

In Designer you can set up an object
and use the Nvl function i.e. Nvl(Field,0) to show zero instead of a null - This may only work with an Oracle database though.

Regards

 

[middletj]

You can opt to display &quot;0&quot; in the data column. Then apply an alerter to the same column which displays the variable if its value is >=0 and also if its value is <0 (ie if a value exists at all).

Cheers - middletj.