Calculated Fields Rounding (Allow calculated properties to display a whole number)
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.
Not having the ability to control the # of decimals makes the reporting or viewing the calculated property in the contact, company, or deal views look very funny.
Agreed that this is very important - both the number of decimal points and the number format of the decimal points are important as we work in a multi-language, multi-country portal where some countries view 1.2 as different numbers.
Is there a status on this update? It's impossible to compare dollar figures when one is an input and another is a calculation that is 5 decimals long and not-rounded.
Please add this feature! Salesforce has multiple options in this area.
It would also be important to solve the problems with the decimals in the reports. When averages are calculated, the result is displayed with many decimal places.
I'm thinking I'll have the calculated property, then have a workflow assign that calculated value to another property each time there's a re-calculation. When decimals appear, we can manually round the non-calculated property up or down. Should work when only a few deals have a qty.5.
Zapier should be able to do it automatically, though.
Thanks for this feedback. Improving calculation property functionality is under consideration for upcoming roadmap. No definite timetable or changes yet, but please keep the upvotes and use cases coming. It helps with designing a solution and prioritizing.
Much needed - the ticket ID's are way to long to use a a reference and there is no way to create a Unique ID for the team to use for reference to the service tickets making it challenging to create greater than 5 or so tickets to an associated Object
The calculation field divideds the ticket ID by 100,000 making a 4 digit number if the abiltiy to round existed - I would also want to be able to set the format to not include the comma - similiar to how ticket tracking in Jira is done
Much needed but not just for calculated properties. Please implement this in the Reporting too (specifically Advanced Reporting). See below, it is silly to have 7 or 9 decimals in reports.
We need to show mortgage rates in this format: X.XX% however when ending in a zero (2.50%), Hubspot drops the zero and displays 2.5% (which our legal dept won't allow), so we have to hard code a zero for certain segments and it is a pain. ;-0
Yes agree. I can live with 2 decimal points in the deals board (prefer optional) but it's incredibly annyoing to see different decimal point fields in calculated fields on deals. How is that not thought through?