Forum Discussion

wallingfordce's avatar
wallingfordce
Data Pipeline
03-23-2022

Stopping an RSUM after its last value

When using RSUM over a category, and when the RSUM has underlying values only for some early periods of time, and not later periods, it sums in the NULLs from those future periods showing values exte...
dashboards & reporting
Ophir_Buchman's avatar
Ophir_Buchman
Data Integration
03-24-2022

Hi wallingfordce 

What you're seeing here is not the default behavior of Sisense as NULL values do not automatically represent zeros. Please try the following:

  1. Change the chart type to "Pivot" and check if the "Missing Data" values show as "0" or empty
  2. If they show up as "0" - Uncheck the "Display Missing Values as Zeros" checkbox

If that's not the case, please:

  1. Share the version of Sisense you're using
  2. Shar a screenshot of the "Pivot" chart
wallingfordce's avatar
wallingfordce
Data Pipeline
03-24-2022

Thanks for this. I'm looking at W2021.4. I was incorrect about my data and did at have zeros in there instead of NULL. I updated the formula to ensure that there are NULL instead of zero. I unchecked display missing as zero. Seems that regardless of 0/NULL and regardless of checked status of display missing as zero, it renders the 0s in the RSUM.

Seems like I should go the support ticket route. 
Thanks