News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Calculated Field is no...

Microsoft Dynamics CRM (Archived)

Calculated Field is not rounding off the values

(0) Share

Report

Report

Posted on by PraveenCRM365

25

Hi,

I have Calculated field with 4 precision of decimal Data Type. Below is the formula (A & B are Currency fields with same 4 precision)

(A-B) / A) * 100

((5.8590 - 4.4600)/5.8590)*100 = 23.877795

When I am setting the value in JavaScript (Manual calculation), result automatically rounding Off

JavaScript result = 23.8778

BUT

Calculated field result = 23.8777

Expected result should be 23.8778 in calculated field

Any Idea why calculated field is not rounding off the values properly?

Thanks,

Praveen

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

gdas 50,085 on at

Like (0)

Report

RE: Calculated Field is not rounding off the values

Hi Praveen,

I think this is expected behavior when you set calculated field with 4 precision of decimal datatype. Try to set 2 precision.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans