Skip to main content
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  ̄_(ツ)_/ ̄
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.
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






Reply