Confluence is showing more than 2 decimal number

Vijay anand R

I created a table in Confluence which is linked with Jira from where the data is pulled to Confluence. 

After creating the table in Confluence I found there are more than 2 decimal numbers showing in the table whereas in Jira that particular data has only 2 decimal numbers.

 

Regards, Vijay

Katerina Rudkovskaya _Stiltsoft_

Hi @Vijay anand R,

If you have the Table Filter and Charts for Confluence app (the add-on is developed by our company) installed for your instance, you may use the Table Transformer macro and the ROUND() SQL function for the case.

For example, your SQL query may look like this:

SELECT *,
ROUND('Column A', 2) AS 'Column A'
FROM T*

Here we leave two decimal numbers (places) for the Column A of your table.