How to indicate specific format for number values at the pivot tables component?

Answered

Hello,
We have your pivot tables component integrated to our web product, and we are having some problems with customers that have the numbers in Spanish formatting ( comma for decimals and dots for thousands). The problem is that the sums that are generated with pivot tables component are not accurate. I’m thinking that we might need to indicate to pivot tables how to treat the number formatting? I checked the doc, and found this link: https://www.flexmonster.com/doc/data-types-in-csv/, but it doesn’t indicate anything about number formatting. Can you guide me to do this?

Here is the CSV that we use as a data source: http://datos.energiaabierta.cl/rest/datastreams/244590/data.csv?pArgument0=2017

We are doing the following operation with the pivot tables (see attachment-01.png). I’m also attaching another image with the correct sum using excel pivot tables (attachment-02.png) 

Here is the pivot tables integration (click on “pivotear” icon on the left sidebar): http://datos.energiaabierta.cl/dataviews/241243/generacion-bruta-en-sistemas-medianos/

Thanks in advance.
Ignacio.-

3 answers

Public
Dmytro Zvazhii Flexmonster October 24, 2017

Hello Ignacio,
Thank you for the detailed explanation. Yes, you right the component is not ready to receive the formatted data in CSV. Please consider the idea of passing not formatted data and then applying the appropriate formatting on the grid. You can do it using the Format object, which is the property of the report object – http://www.flexmonster.com/api/format-object/.
Please let us know if everything works fine for you.
Regards,
Dmytro.

Public
Ignacio Sans October 24, 2017

Thanks for the explanation. I will review our implementation and will contact you if I need more information.

One more question: We are thinking to change to a JSON data source implementation to implement these changes. Will I need new keys for our customers? 
Regards,
Ignacio.- 

Public
Tanya Gryshko Flexmonster October 25, 2017

Hello, Ignacio,
Your current keys will work with JSON data source as well.
Should you have any other questions – feel free to ask.
Regards,
Tanya

Please login or Register to Submit Answer