Calculated Fields Rounding (Allow calculated properties to display a whole number)

[mikee]

The current behavior for calculated properties is to round to two (or more) decimal places. It would be helpful to instead allow results to be rounded to the nearest whole number (an integer) – instead of two decimal places. Even better would be to either round or adjust decimal places up or down like in Excel.

This would allow more flexibility when presenting data as a Report in a Dashboard. Usually in a chart or other visualization showing accuracy down to .01 is unnecessary.

Stated differently, please add the ability to adjust calculated properties to either display a whole number or precisely specify the number of decimal places.

[TFolkertsma]

This is a needed function to configure roundups after the . or , 

[JHolzendorff]

Will this be fixed ? Its a nigthmare for our SalesTeam

[PSwift]

Great news HS are looking into this, reading other related posts, could combibe the other requests to allow users/admins to select how many decimal places the number is rounded up to please?

[Stanz]

Is there an update on this?

[JLeserDDK]

Product team at HUBSPOT. We really need this specially now that customized objects are being widely deployed. Not rounded numbers in calculated properties really shows the data results in an ugly format and causes mistakes. Thank you.

[jifchen]

Hi Hubspot - after 4 years and 222 votes, hope you guys do something about it soon!

[ChrisDraeger888]

Please we need this

[ChrisPower1]

We're currently getting 5 or more decimal places in the results of a calculated property.  Being able to control the rounding is a much needed feature. 

[TGagnon]

Hi, just adding to the post. This is goofy. 

[MCundall]

This is absolutely needed.  Any idea when it will be implemented?

[auto-mate]

Coming up to 5 years.

REally want to remove those decimals and round to a hundred!

[EPuffenbarger]

Hi all,

Just FYI, I think this has been addressed. There is a way to insert a function into your calculated properties:

round_up()

round_down()

round_nearest()

Then you just define the decimal place precision, which would be 0 if you're looking for a round number.

Example: round_nearest(your-calculation-goes-here, 0)

[auto-mate]

@EPuffenbarger only works to round decimals. Would like to be able to round to miillions, thousands, hundreds etc.

[KBush8]

Hi HubSpot Team,

It looks like the last update on this was 2 years ago; wanted to follow-up and see if there's a fix for this or if you have a timeline for implementation?

Thanks,

Katie

[hhiggins]

Hi everyone!

This idea's status has changed from ‘Being Reviewed’ to ‘Idea Submitted’. This change is due to our improvement project to update our Ideas Forum statuses in order to provide better transparency into how we are listening to your feedback.

“Idea Submitted” means that our product teams are aware of this feedback and are monitoring the need for this feature alongside other inputs that determine their priorities & roadmap.

For more details about the statuses we use on the Ideas Forum & what they mean, you can read this community post here.