Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Rollup field and calculated field not working

Posted on by 760

Hi,

I created a calculated and rollup field but both are not working. I was able to save the field because there was no error in formula

1780.calculated.PNG2211.rollup.PNG

*This post is locked for comments

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Rollup field and calculated field not working

    Hi Jane ,

    Seems the  condition you have implemented is correct. Just to make sure for calculated field you need to save the records  and for rollup you need to wait at least 12 hours till asynchronous process execute the roll-up condition.  

    And also please try with sample provided by MS in below reference to check whether these samples are working or not in your CRM instance.

    technet.microsoft.com/.../dn832162.aspx

    technet.microsoft.com/.../dn832103.aspx

    Hope this helps.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rollup field and calculated field not working

    Hi Jane,

    Rollups are set to refresh every 24 hours; they don't automatically re-calculate on save or refresh of the page. Did you refresh the page or the roll-up field itself?

    Try to set Use Hierarchy:Yes

    Thanks

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Rollup field and calculated field not working

    Hi Jane,

    For calculated field, did you save the record? Does Vat field has any value? Calculated fields works on save of record.

    For rollup field, it works every hour. Did you try to click on manual rollup button on the field? Does it display the current time?

    Can you confirm if this is not working for all users or just for you?

    Hope this helps.

  • gdas Profile Picture
    gdas 50,085 on at
    RE: Rollup field and calculated field not working

    Hi Jane ,

    Is it possible to share the screenshot of your calculated field and rollup field criteria so that we can 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

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans