Trouble in pivot demo

[hyh888]

When I change the pivot demo's foumula to make it do division( line 89-------  var total = rd.gold /rd.silver; ), I found the "sum(total)" column's value change to "infinity".
Is there any solution for it?

[paramvir]

isFinite() check can be used:

Code: [Select]

formulas: [['total', function(rd){
    var total = rd.gold /rd.silver;
    return isNaN(total) || !isFinite(total)? "": total;
}]],                                                     


[hyh888]

Dear Paramvir,
Thank you very much for your reply, but when I tried your solution in your demo, almost all results are wrong(even not "infinit").
In the following pic, in the 1st line, the result should be between 2 and 3, but it becomes 8.

[hyh888]

Dear Paramvir，
Should this issue be treated as a bug?

[paramvir]

This is answered here: https://paramquery.com/forum/index.php?topic=4648.0