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.

8 Replies
New Contributor

Much needed!

New Contributor

Was also looking for this.

Visitor

Very much needed. At present I have a calculated property sitting at 5 decimal places. I'd be happy with even two at this point. 

Capture2.PNG

New Contributor

please, please, please! add this in as a capability! Smiley Happy 

New Contributor

does anyone have a work around for this, or suggestion for what to do instead?

 

we have caluclation properties that are currency fields, and some of the values are appearing as $208,916.668

 

that looks pretty funny as a $$ amount. 

 

please let me know if you've figured out a hacky way to fix this!

Advisor

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. 

 

Please add this feature!

New Contributor

Yes please add this feature...

Top Contributor | Platinum Partner
Top Contributor | Platinum Partner

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.