1. Feedback
  2. JavaScript
  3. 41568

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Pivot table calculated field calculates incorrectly when there are several formulas referring to column itself

The issue can be seen in this demo: https://stackblitz.com/edit/demngl

In this pivot table, I can see data: 7.0 1.6 1.6

What is expect to see is: 7.0 1.3 1.6

The second number should be calculated as (3+6)/(2+5)=1.3

Calculations are working, if using only one of the calculated fields, but when using both, the first shows incorrectly.

Strangely, if I change the first formula from "Sum(b)" / "Sum(a)" to "Sum(c)" / "Sum(a)", it shows correct results, but this formula seems very illogical.