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.

nic Community Leader Jan 17, 2017

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

nic Community Leader Jan 23, 2017

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
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

3,842 views 15 38
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you