Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Trying to get Rollup field of sum of Activities under Campaign.

Posted on by 50

Hello, we are having trouble getting a rollup sum for all Activities under Campaign. We are trying to get a count of all activities from regarding. It seems to be possible from this Microsoft article. https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-rollup-fields 

Below please see our current setup. 

pastedimage1601914640425v1.png

Here is a view of the Activities we are trying to roll up to the Campaign.

pastedimage1601915007469v2.png

Here is a ss of Campaign showing the roll up is not working.

pastedimage1601915156595v3.png

Any help would be appreciated.

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Trying to get Rollup field of sum of Activities under Campaign.

    Hi CSGATX,

    Could you check if the record of Regarding field of activities is the Campaign record you are looking at?

    pastedimage1601971049326v2.png

    In addition, activities related to this Campaign will appear in the timeline, and you can use this to check the number of activities.

    pastedimage1601971035608v1.png

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Trying to get Rollup field of sum of Activities under Campaign.

    Hi,

    I have created same rollup field on my crm instance and it is working as expected.

    CQ29.PNG

    CQ30.PNG

    1. Make sure you have created the field as Whole Number field data type.

    2. Please click Recalculate button to calculate roolup field sync

    3. Add Total activities (State) field on the form along with last updated and Total activities. Check my image screenshot. State field will tell you the reason of failure.

    0 => NotCalculated The field value is yet to be calculated.
    1 => Calculated The field value has been calculated per the last update time in _date field.
    2 => OverflowError The field value calculation resulted in overflow error.
    3 => OtherError The field value calculation failed due to an internal error. The following run of the calculation job will likely fix it.
    4 => RetryLimitExceeded The field value calculation failed because the maximum number of retry attempts to calculate the value was exceeded due to high number of concurrency and locking conflicts.
    5 => HierarchicalRecursionLimitReached The field value calculation failed because the maximum hierarchy depth limit for the calculation was reached.
    6 => LoopDetected The field value calculation failed because a recursive loop was detected in the hierarchy of the record.

    Please mark my answer verified if i were helpful

  • CSGATX Profile Picture
    CSGATX 50 on at
    RE: Trying to get Rollup field of sum of Activities under Campaign.

    Yes, we have clicked the manual update and still not calculating anything.

  • RE: Trying to get Rollup field of sum of Activities under Campaign.

    Rollup fields are asynchronous in nature, they will take sometime to run and update. Did you try clicking on Refresh button (Calculate button just before the label) and check?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans