How to Round off values in Table Transformer in Confluence.

[Balaji Mohanraj]

Hi Team,

Please advise how can I round off the values shown in the first screenshot.

Thanks,

[Stiltsoft support]

Hi @Balaji Mohanraj ,

Please check the ROUND() function once more: it should include 2 arguments - number/expression and the number of decimal places.

For example, SELECT ROUND(345.156, 0) will give 345 as a result.

Also go to the Options tab of the Table Transformer macro and set the number of decimal places as 0: it should work for the numbers calculated within the Table Transformer macro even without the ROUND() function.

[Balaji Mohanraj]

Thank you so much for looking into my concern and sharing the suggestion, will definitely check on it and get back If further more assistance is required.

[Balaji Mohanraj]

Hi Team,

Please check on the below , I am trying to execute below query but it is not getting round off , any suggestion please.

ROUND(cast(100 - 100*cast(T1.'Remaining Time' as decimal)/cast(T1.'Story Points' as decimal) AS DECIMAL),0) as 'Reached Progress in %'

[Stiltsoft support]

Hi @Balaji Mohanraj ,

Please refer to our support. Attach the page storage of your page (upper right corner -> menu ... -> View storage format), so we will be able to recreate your source page. If your source table is a Jira Issues macro, then attach its screenshot in a published state without any macros.