🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Max aggregation is incorrect when all values are negative

Projet TCD asked on January 10, 2019
  • Version: Pivot Table for JSON data sources 2.6.11 (Jan 02, 2019)
  • Browser: Chrome 71.0.3578.98 on MacOS 10.14.1
  • Link to reproducehttp://jsfiddle.net/hxygpj8c/1/
  • Steps to reproduce:
    • Display pivot
    • Check that there are 2 rows in “Group” and 2 corresponding values in “Total Max of Amount” that are negative
    • Check result “Grand total” of “Total Max of Amount
  • Observed behavior:
    • Result is “4.940656458412e-324” (or 0 depending on browsers)
  • Expected behavior:
    • Result should be “-1 234.56
  • Notes:
    • Observed behavior occurs when aggregating 2 values or more.
    • Observed behavior only occurs when all aggregated values are negative or zero
      • Having a positive number in the data returns the max. positive value correctly
    • Observed behavior also applies when grouping, on sub-totals by column or row
    • Observed behavior also applies when the grand totals are by column or row
    • There are no trace in Chrome JS console


2 answers

Tanya Gryshko Tanya Gryshko Flexmonster January 11, 2019

Thank you for providing all the details about the issue. It really helped us to reproduce it on our side.
Our development team will fix it. The update containing this fix will be released on February the 11th.
Please inform us in case of other questions.

Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 12, 2019

We are glad to inform you that the issue with the max aggregation has been resolved.
You are welcome to update the component and try it.

Please login or Register to Submit Answer