We have changed our pricing. Flexmonster Software License Agreement was also updated (list of changes)
Get Free Trial
Get Free Trial

[Bug Report] Formula returns wrong values when hierarchies are moved in the grid

posted on July 9th, 2020

Resolved
Projet Data asked on July 9, 2020
  • Version: Pivot Table for JSON data sources v2.8.10
  • Browser: Chrome Version 83.0.4103.116 on Windows 10
  • Link to reproduce: https://jsfiddle.net/t79zqsco/
  • Steps to reproduce:
    • Open attached JSFiddle
    • See values for measure "Balance Start" on 2013 and Totals (e.g. for Country "BE" it is 1 476.76 in 2013)
    • In the grid, drag the hierarchy "Country" from the rows to the columns and then drag it back from columns to rows (to restore initial configuration)
    • See values for measure "Balance Start" on 2013 and Totals once again
  • Observed behavior:
    • "Balance Start" on 2013 and in Totals has different values (e.g. for Country "BE" it is now 2 191.47 in 2013) (see attached screencap)
  • Expected behavior:
    • "Balance Start" (or any measure based on a formula) should not return different values when hierarchies are moved through drag&drop and then restored back to the initial configuration
  • More details:
    • "Balance Start" is a formula based on 2 runningtotalsofrow calculations. Bug doesn't seem to occur with only one runningtotalsofrow in the formula (untested with other aggregations)

Attachments:
image.jpg

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ July 10, 2020

Hello,
 
Thank you for reporting the problem.
 
The fix is going to be provided with a minor update ETA Aug 11.
We will notify you as soon as the version with a fix is released.
 
Do not hesitate to contact us in case further questions occur.
 
Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ August 11, 2020

Hello,
 
We are glad to inform you that the issue with inconsistent behavior of drag and drop feature for calculated measures was fixed.
This is provided in the 2.8.13 version of Flexmonster.
 
You are welcome to update the component.
 
Please let us know if everything works fine for you.
 
Best regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ August 19, 2020

Hello,
 
Our team is wondering whether the fix did manage to resolve the problem for your case.
 
We are looking forward to hearing from you.
 
Best regards,
Illia

Please login or Register to Submit Answer