Why not to display the "0"?

[nocquidant]

Why not to display the "0" in numberFormat?

 numberFormat = function(sigfig, scaler, thousandsSep, decimalSep) {
    ...
    return function(x) {
      // if (x === 0 || isNaN(x) || !isFinite(x)) {
      if (isNaN(x) || !isFinite(x)) {
        return "";
      } else {
        return addSeparators((scaler * x).toFixed(sigfig), thousandsSep, decimalSep);
      }
    };
  };

Thanks for your work!
++nick

[nicolaskruchten]

It's an aesthetic choice. You can always swap in your own number formatter if you want to see the zero :)

[nocquidant]

Ok thanks for the tip.

FYI, I had to change in pivot.js direct references to numberFormat to $.pivotUtilities.numberFormat (in order to reference my own numberformat attached to $.pivotUtilities.numberFormat).

[nicolaskruchten]

I've just updated the Aggregators documentation to make it clearer how you can control the output format: https://github.com/nicolaskruchten/pivottable/wiki/Aggregators#built-in-aggregators-and-aggregator-templates

[nicolaskruchten]

Updating an old issue: this aesthetic choice has been reversed, and zeros are always displayed now when there is data in the cell (i.e. 'count' will never show zero because there is nothing to count).