5 Replies Latest reply on Sep 8, 2016 1:15 PM by Paraskev Bentchev

    Aggregation of Null Values in Sheet Title shows as "All" instead of "Zero"

    Matt Fischer

      I have a sheet that shows a metric by weeks, and then a calculated field in the sheet title that shows me how many were yesterday. When there are none yesterday (thus passing in a NULL for that calculated field), it shows as "All Yesterday" in the title. I went ahead and made another calculated field that just says IF NULL then replace with 0. That works when it is null. However, when it is NOT null, then it reads as a range, "0 to 4 Yesterday". What am I doing wrong here? Why is it saying "All"?

      ALL Yest.pngISNULL.png

      Title.pngNullYesterday.pngYesterday Count.png