Pivot Table Operations String format

Hi there,

I would like to add a custom operation to the Pivot table using:
$$(“pivot”).operations.mycustom = function(data) { return “test” };

When I try this, my column displays the value NaN.

Is there anyway around this?

Thanks.

Hi,

An operation function must return numeric value, and it is a string in your example:

$$(“pivot”).operations.mycustom = function(data) { return 100 };

Thanks Maria!

How can I get rid of the text NaN when there is no value for a particular cell?