Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Rounding issue in the decimal field

Posted on by Microsoft Employee

Hi All,

In CRM Dynamics online, I have a requirement to display a calculated field with 2 decimal places.

But If I key-in the amount with last 2 digit less than 0.50, then it automatically rounding-off to smaller value leaving the decimal to zero. On the other hand, If the last two degit is more than or equal to 0.50, it is rounding to next higher value leaving the decimal to zero.

How to resolve this issue? Need your help.

Regards

San

*This post is locked for comments

  • DorienM Profile Picture
    DorienM 30 on at
    RE: Rounding issue in the decimal field

    Hi Bhanu, were you able to resolve this. I am having the same issue.

  • Vidyuth Profile Picture
    Vidyuth 55 on at
    RE: Rounding issue in the decimal field

    I have a similar issue where it's rounding off to the nearest value, i.e. if value is 12.46 - it shows 12.00. If value is 15.85 - it shows as 16.00. I have Precision set as 2 digits for that field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue in the decimal field

    SANRAJESH, How are you calculating the amount? Aren't you using any other field to calculate?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue in the decimal field

    Yes. The precision at field level is 2. But still its checking the currency only.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue in the decimal field

    If there is only one field, then how it is being calculated? Did you check the precision at field level and system level?

  • Suggested answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,397 on at
    RE: Rounding issue in the decimal field

    Hi

    Please check the precision for this field is set to 2.

    Amount field is a calculated field?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue in the decimal field

    No. There is only one field called "Amount". Its rounding to upper limit or lower limit based on the amount I key-in.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding issue in the decimal field

    Are you sure that both the fields have decimal points set to 2? Also check system settings for decimal formatting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans