How to show null values as zero?

[#1]

How to show null values as zero by script?

Ex: If COMM=NULL then 0 else COMM

[#2]

Dear JJR,

Convert null values to 0 using simple expression,

=Alt(FieldName, '',0)

Kind regards,

Ishfaque Ahmed

Thank you Ishfaque Ahmed. It is also working fine.

[kumarravi]

Hey mostly I have seen isnull() function is being used in this:

Example:

If(IsNull(Col_name),0,col_name)