Hi,
I'm trying to apply a format rule for a field with time type and average aggregation.
It works as expected when using max, or count (or any aggregation that doesn't yield a float number), but with average I can't truncate the number. This field even transforms the integer value (from json data source) into "HH:mm:ss" format but with decimals number after the seconds (for example, when the result of the average aggregation is 567.13333333333333 he transform into "00:12:23.1333333333"). Same issue when exported to excel.
I tried to init a predefined format (it works fine with number types, even with average aggregation) and using the "Format Cell" window after data loaded.
The Flexmonster PivotTable version is “Version 2.403 (build 11/09/2017 09:44:07) – Edition: CSV/JSON/SQL Unlimited – Pivot Table & Charts Component – Developer’s version“. I tried loading the default language and the “Portuguese” translation JSON. I tried the 2.4 version too.
Regards
Elizeu Madeira
Hi Elizeu,
Thank you for reporting the issue. It was reproduced on our side and it will be fixed in the minor version 2.406 (ETA - Oct 23).
Please let us know if this works for you.
Kind regards,
Iryna
Thank you!
We will wait
Regards,
Elizeu