Issue in suppressing a text object conditionally

[dev1212]

Hi,

I want to display '$0.00' when the amount is null or blank.
I cannot use 'Convert database null values to default' as i am using distinct count for another field.

I created a text object and wrote '$0.00' in it and on
Right click -> Format field -> on formula for conditional suppress of that field

IsNull(ACCT.AMT)=FALSE
or
Trim(ToText(ACCT.AMT)) =''


It works fine most of the time but i am getting '$0.00' randomly on the report like,

My Report is like,

Name Amount Active
AXX $2300.00 1
AXB $4732.21 0
$0.0
AXD $0.0 1
AXF $765.22 1
AXN $0.0 0
AXP $4327.43 1
AXQ $877.32 0
$0.0
AXZ $877.33 1



How to avoid the occurence of '$0.0' only when the amount is null.


Any solution would be greatly appreciated.


Thanks

 

[dev1212]

ok..
Forget about this guys.. i changed the SQL and used decode funtion to return 0 when NULL..
This issue is solved now..

Thanks