Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Roll Up Currency Fields

Posted on by 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

  • 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 Microsoft Employee 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans