Max aggregation is incorrect when all values are negative

posted on January 10th, 2019

Resolved

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: http://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

Attachments:
screen_01.png

2 answers

Public

Tanya Gryshko ⋅ Flexmonster ⋅ January 11, 2019

Hello,
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.
Regards,
Tanya

Public

Dmytro Zvazhii ⋅ Flexmonster ⋅ February 12, 2019

Hello,
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.
Regards,
Dmytro

Max aggregation is incorrect when all values are negative

2 answers

Please login or Register to Submit Answer