Rounding issue in the decimal field

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

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

Amount field is a calculated field?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Vidyuth 55 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
DorienM 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No