Hi,

I’m using the Pivot Table and want to add my own custom formulas for calculating the totals.

The best way that I have found to do it is to use the following:

var grid = $$(“pivot”).$$(“data”);

grid.config.columns[4].math = “customTotal([$r,:1],[$r,:2],[$r,:3])”;

My code is much more complex than this, but this illustrates the basics of what I am trying to do.

The issue I am having is some of the values in the row are non existent in the datasource therefore equal NaN which is ok, but when I reference the particular row/column with [$r,:1], the NaN is converted to 0 which is not desirable.

Is there another way to retrieve the raw values or a false if they don’t exist?

Thanks.