Menu
Download Free Trial

How can I truncate Values of a column?

 Hi,
We have data which has values after decimal for more than 8 digits. I am just wondering, if I can truncate the values by rounding them off till 4-5 digits or as required.
For E.g. The number 33 164 160.700699992 can I truncate the decimals and make it to 33 164 160.70067.
I have attached a csv dump for your reference.It would be great to have this feature.

Attachments: pivot (4).csv

2 answers

Public
Ian Sadovy Flexmonster July 8, 2016

Hi Mithil,
 
Yes, you can achieve this by using the formatting feature.
It is available via UI – http://take.ms/ddgRC or you can specify the format in the report Object, please check this demo – https://jsfiddle.net/iansadovy/jbye2Lj8/
Hope this helps.
 
Regards,
Ian

Public
Tanya Gryshko Flexmonster December 7, 2016

Hello Mithil and all Flexmonster users,
After the release of version 2.3, we would like to provide you with the updated sample: https://jsfiddle.net/flexmonster/0d0hdz7z/.
Regards,
Tanya

Please login or Register to Submit Answer