web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Calculated currency field
Microsoft Dynamics CRM (Archived)

Calculated currency field

(0) ShareShare
ReportReport
Posted on by Community Member

Hello, i have question about currency field. I have base currency EURO. i have entity Account and 1:N relationship to custom entity. On account form i have calculated field with action customentity.currencyfield + account.currencyfield. If i chose base currency EURO, everything is ok. But if i chose other currency. For example USD. the result of calculated field is wrong.

For example - customentity.currencyfield value = 125000 USD, account.currencyfield value = 80000 USD. the result is 204999,94 USD.

Version 8.2

Any idea why this behaviours? Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    it is a conversion problem. I suppose your base currency is Euro. Then when you are giving 80000usd this value will be stored in the currency field but also in the base currency field(it will use the exchange rate that you gave to crm to save it in euro).

    Finally when CRM will add to value it will to do it in the base currency.

    The all problem comes from the trucation/precision of your field currency, i.e. if the exchange rate is 1Euro = 1.23456 USD and your filed precision is 2 then the saved value will be 1.23 USD => you loose 0.00456 usd and withe large number it becomes significant.

  • Community Member Profile Picture
    Community Member on at

    Thank you for the explanation. I thought so, but he hoped it was different.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans