Get Free Trial

How can I truncate Values of a column?

Mithil Thakkar asked on July 7, 2016

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.

pivot (4).csv

2 answers

Ian Sadovy Ian Sadovy Flexmonster July 8, 2016

Hi Mithil,
Yes, you can achieve this by using the formatting feature.
It is available via UI – or you can specify the format in the report Object, please check this demo –
Hope this helps.

Tanya Gryshko 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:

Please login or Register to Submit Answer