Show Null values as a number

Hello Helical,

Is there a way we can convert the null on the database to show 0 instead of null? If so how do we change it?

Thank You

1 Like

Hello Priya,

This can be done by using Custom Column.
Create a custom column and write the condition:
IFNULL(<Column_Name>,0)
You can also use the if DBFunction present using the “More” option. To learn more about using custom column click here

Please Note: The function will depend on the database that you are using.
image

Thank You
From Team Helical