Asked by:
Is there a way to only show whole number part of a 2 place decimal field?
Question

Hello,
In CRM 2013, I have a field which datatype is 2 place decimal. Is there a way to only show whole number part?
For example, if user only input 60 in the field, it only shows 60 instead of 60.00. if user enters 60.00, then it shows 60.00.
I know I can define the field as text field, in that case the field can either take whole number or decimal. But end users need to do sum or average kind of calculation while they run chart.
Thanks.
 Edited by howexg9 Tuesday, December 1, 2015 12:04 AM
Monday, November 30, 2015 11:50 PM
All replies

Tuesday, December 1, 2015 7:45 AMModerator

You could change the field so that it has 0 decimal places, which will mean it stays the same datatype. But then this would prevent entry of values with decimal places  is this what you want ?
Microsoft CRM MVP  http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
Tuesday, December 1, 2015 10:56 AMModerator 
No. I still want to keep 2 place decimal. So if user enter like 60.56, it will still show 60.56.Tuesday, December 1, 2015 3:27 PM

You could change the number formatting on just the chart itself. That could be conditional on whether or not the number contains decimals or is just .00. Or simply round it to nearest whole number. The change would only be in chart though. In the form the number would still have 2 decimals.
See instructions here on formatting the labels in charts.
Ulrik,
Blog: http://crmchartguy.wordpress.com  Exclusively for MS CRM Charts
Twitter: crmchartguyThursday, December 10, 2015 3:01 AM