Hi Team,
Please advise how can I round off the values shown in the first screenshot.
Thanks,
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.
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.
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 %'
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.
It looks like you're new here. Sign in or register to get started.
