Hi All,
Let me start by saying we are using an on-site solution (Dynamics CRM 2013) and that I am fairly new to working with this product (approx 5 months).
While working on an entity that was created prior to my joining the team, I encountered the following issue.
I have a whole number field on an entity and am attempting to create a chart that displays the average value of that field. Seems simple enough. The problem that I'm running into is that the average is rounding down to the nearest whole (i.e. 9/2 = 4). Through testing I've determined that this is happening because of the field type, and that this doesn't happen when using decimal or float values.
Is there any way to force the system to treat the whole number field as a decimal value for charting purposes?
I would rather not have to go back, add a new field and then back-fill the data across the historical records because many of those records are completed and would need to be re-opened to update. This, in turn, would affect other values we use on a regular basis (Last Updated, for example).
Thank you for any insights you can offer.
