Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
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 reproduce
  • 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 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 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