0 votes
1 view
in BI by (15.1k points)
I need to classify my dataset into groups depending on sales and store wise details. I'm fetching my data from the database, so it contains null or empty values. How to replace them with 0 for calculation purpose.

How to display 0 if there is no data (null or empty) corresponding to that field in a row?

1 Answer

0 votes
by (41.2k points)

Hi Vaibhav,

To replace null or empty values you can use ZN() or ISNULL() to check and show 0.

Using ZN()

ZN function is basically used to return 0 or not null values for a column. It takes a field as a parameter.

ZN([Phone No]) would return phone no if or null else gives 0.

Using ISNULL() -

 ISNULL([Field] returns true if value is NULL.

Hope this helps you.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !