Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Calculated field is not showing up in rollup field of 1:N relation entity

Posted on by Microsoft Employee

Hi,

I am not able to get the calculated field displayed in the sum aggregate function of rollup field i am creating in ms crm 365 v9.0.

Also, the calculated field contains the formula as such <lookup>.<currencyfield>*time field.

Is this what is causing the issue?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated field is not showing up in rollup field of 1:N relation entity

    The calculated field is not using any another calculated field, it is simply doing a calculation as Revenue = total time * (Project) billing rate, however the field is also not populating nor it can be seen under my rollup field of project entity... However Project share 1:N relationship.

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: Calculated field is not showing up in rollup field of 1:N relation entity

    Hi There,

    docs.microsoft.com/.../dn832162(v=crm.8)

    A rollup can't reference a calculated field that uses another calculated field, even if all the fields of the other calculated field are on the current entity. Based on that if your calculated field does not reference another calculated field, this should work.

    Also, consider that Rollup fields execute asynchronously, so you might not see the results immediately.

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