Confluence is showing more than 2 decimal number

Vijay anand R April 11, 2023

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, VijayConfluence.JPG

1 answer

4 votes
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 11, 2023

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events