How can I truncate Values of a column?

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

1 answer

Ian Sadovy Staff 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.

Please login or Register to Submit Answer