Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to show null values as zero by script?
Ex: If COMM=NULL then 0 else COMM
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.
Hey mostly I have seen isnull() function is being used in this:
Example:
If(IsNull(Col_name),0,col_name)