Zero displaying as blank in report/ dashboard

  • 1
  • Problem
  • Updated 2 months ago
I have a tabular report where a numeric field is being aggregated to show the average of values. If the average equals 0, the report displays a blank cell– in my case, the average of two values {0,0} = 0. The same happens if I choose any of the other aggregation methods if, in fact, all values in the set equal 0.

It'd be helpful if the report displayed a 0, instead of a blank. Blank looks like there isn't data when there really is data– the values just all happen to be zeros. 

I did see a similar thread here, but I think this scenario is a bit different in that there are values populated on the records. i.e. I don't think this is a case where there's an absence of data, but I could just be being dense  ̄\_(ツ)_/ ̄
Photo of Pele

Pele

  • 2,464 Points 2k badge 2x thumb

Posted 2 months ago

  • 1
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,626 Points 10k badge 2x thumb
Hi Pele,
I understand we have issue displaying zero while "absence of data" (The linked post), but we didn't understand your issue. Could you please a video for better understanding.
Photo of Pele

Pele

  • 2,464 Points 2k badge 2x thumb
Hi Sai,

Thanks for the response. Below is a clip of what I'm running into. In this report, I have 3 numbers– all zeros. If I group by Survey Title and aggregate Sample Data by anything other than "Count" or "Count Distinct" the results will display as blank. 

I think what I'm really trying to get at here is "0" isn't a null value, and the aggregation methods should display "0". 

Cheers,
Pele