Customer experience | Sales, Customer Insights,...

How to show 2 decimal places but calculate with 5 in Dynamics 365 Sales?

(1) Share

Report

Posted on by r4vvm

204

In Dynamics 365 Sales, we've set currency precision to 5 decimal places to support accurate calculations (e.g., Price Per Unit × Quantity). However, this causes all currency fields to display 5 decimals, which looks messy in the UI.

We want to calculate using 5 decimal places but only display 2 decimal places to users. I know JavaScript could format the display, but I don’t want to run JS on every form just to fix this.

Is there a supported way to separate display precision from calculation precision? Or any workaround that doesn’t involve overriding every form with JavaScript?

Thanks in advance!

Categories:

Dynamics 365 Sales

I have the same question (0)

All responses (3)

Answers (0)

#ManoVerse 455 on at

Like (1)

Report
How to show 2 decimal places but calculate with 5 in Dynamics 365 Sales?

you can follow below approach.

Create a hidden currency or decimal field with 5 decimal places.

Use this field for all calculations.

Create a second visible field with 2 decimal places to show the rounded value.

Use a calculated field or Power Automate to copy and round the value.

Was this reply helpful? Yes No
r4vvm 204 on at

Like (0)

Report

How to show 2 decimal places but calculate with 5 in Dynamics 365 Sales?

Thank you, How can i use this new hidden field for the calculation?

Was this reply helpful? Yes No
Suggested answer

#ManoVerse 455 on at

Like (1)

Report

How to show 2 decimal places but calculate with 5 in Dynamics 365 Sales?

sorry for noticing your reply late , you can use fields like this

Revenue 5 would be your calculation field by plugin process or whatever, and Revenue 2 decimal field would be your showcase field.

Revenue 2 decimal field would be calculated field

I hope this will clarify

Was this reply helpful? Yes No