It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

decimal value in confluence

How can we remove decimal from confluence? Please find attached screenshot for reference.image2017-1-18 10:21:20.png

I have made change in General configuration. See attached screenshot.

 

image2017-1-18 10:22:47.png

 

1 answer

Hi,

It looks like you're using a Page Properties Report to generate that table.  The Page Properties Report just provides a faithful report of the the data in your Page Properties macros, so if the decimal is in there it'll be displayed in the Page Properties report.

It looks like a JIRA macro for filter results to me, but even if it is, the principle is the same - it's a faithful representation of the data the macro is reporting on.

Good point, I hadn't noticed the column on the right....

Thanks Rob/Nic for valuable inputs. How can we fix this? Do I have to make any config changes?

Hi,

I'm afraid you can't "fix" it, because it's not broken - this is intended functionality.  The reports in Confluence give you a faithful rendition of the data they're reporting on, so the only way to avoid having decimal places in the values in your report is not to have decimal places in the values in JIRA that you're reporting on.

(Bear in mind that Confluence is a wiki, it's not a data processing tool like Excel.  It's not designed to do numerical operations like rounding, or calculations on data.)

Hello Rob,

 

I am pulling reports from JIRA where field value is not having any decimal places. Still on Confluence it is showing decimal values. We want to stop this behaviour of confluence.

 

Thanks

If the field doesn't have any decimal places, that implies you've changed your JIRA look and feel to hide it.  It's still a numeric field though, and that's how Confluence reads numeric fields.

 

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 (you can also ...

2,483 views 14 20
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you