web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Roll Up Currency Fields
Customer experience | Sales, Customer Insights,...
Unanswered

Roll Up Currency Fields

(0) ShareShare
ReportReport
Posted on by UDA_Solomon 15

I am attempting to roll up a currency field.

  1. First, In entity A, my currency field was created and is placed on the form.
  2. In CRM online the currency field is the trasnactioncurrencyid
  3. I made an additional currency input field titled "Withdrawals" and another titled "Deposits"
  4. In the form of entity A where the fields "Withdrawal" and "Deposits" are I placed the "USD currency" field.
    1. I did see another post stating to set the value for this field. Does this mean select the currency? I am a little confused here.
  5. Entity B is where I have the Roll up field created, its is also in currency. 
  6. In the form of entity B I have also placed the "USD currency field" where I have the currency fields "Withdrawals" & "Deposits".
  7. In the calculation field I selected the related entity as entity A.
  8. I selected to roll up by SUM the "Deposits" field, Saved & Closed successfully.
  9. After the record is created and I go to the Roll up field and select the "Recalculate" button it is not calculating
  10. The value of 0.00 shows but the Roll up field is not calculating.

Summary and example:

  • Entity A has currency fields "Withdrawals" and "Deposits"
  • Entity B has the Roll up fields related to Entity A's "Withdrawals" and "Deposits"

Screen-Shot-2020_2D00_01_2D00_14-at-5.31.12-AM.png

I have the same question (0)
  • UDA_Solomon Profile Picture
    UDA_Solomon 15 on at
    RE: Roll Up Currency Fields

    Hey Tally,

    Its a collection of deposits and withdrawals a total amount.

    Yes there are amounts in the children.

    I just used Flow to get this done. I appreciate the help Tally.

  • Community Member Profile Picture
    Community Member on at
    RE: Roll Up Currency Fields

    first of all, transactioncurrencyid is not an amount.  it's a currency. e.g. USD.  probably a good idea if you map it on the parent/child relationship.

    you pressed the recalculate button at 5:20 AM?

    it is odd that the child field is plural.  I assume it is just one amount.

    are there actual amounts in the children?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 141

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 132

#3
DAnny3211 Profile Picture

DAnny3211 130

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans