cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering of null values out from Sisense

amelia
10 - ETL
10 - ETL

Hi! I am currently facing an issue with one of my dashboards - rows with null values are being hidden after some filters are applied. This affects other columns of data, since some of them use RSUM. The RSUM values are wrong since the rows with null values are being deleted. Can i check if there is any way I can resolve this? 

1 REPLY 1

ronenavidor
Sisense Team Member
Sisense Team Member

Hi Amelia,

You can create a custom column in you data model, and replace all null values with the value of zero. Then use the newly created column as part of your RSUM function.

Hopefully that helps.

Ronen