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.