Replace null with 0

Adhoc
, , , ,
#1

Hello Team ,

I am using open source BI Helical Insight 5.1 enterprise edition. While I am working on tabular report, I am getting null value from the db. Could you please assist us in converting null into ‘0’ or blank ?

Thank You,
Netta.

#2

Hello,

This can be done in two ways:

  1. Modify the project.properties file

Open the project.properties file from the following server path:

“../hi/apache-tomcat-9/webapps/hi-ee/WEB-INF/classes”

Replace Null on line 12 with an empty:

# The null value to be used

nullValues=Null

Restart the Helical Insight server. With this method for any current and future report also, null will be replaced with 0.

  1. If you want to apply for any specific report:

This can be handled using database functions, custom columns, or at the view level also.

Thank You,
Helical Insight.