isnull function 2

[QueSpr04]

I am using CR10 and a ODBC connection. And I am trying to get a running total to display $0.00 if the field has a null value. Any solutions?

 

[kutoose]

Can you try this :

Go to File -> Report Options. Check the 'Check Box' next to 'Convert Database NULL values to Default'

kutoose@yahoo.com

 

[Madawc]

Alternatively, try

if isnull({your.amount}) then 0 
		         else {your.amount}

Madawc Williams (East Anglia)

 

[QueSpr04]

The result of this formula must be boolean", is the result of the formula [if isnull({your.amount}) then 0 else {your.amount}

 

[lbass]

Sounds like you are creating the formula in the wrong area. This should be created in the formula editor in the field explorer (not sure where this is in CR 10). Make sure you are not in the record selection area or a conditional formatting formula area.

-LB