web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Actuals for a goal after a user selects recalculate does not reflect participating records

(1) ShareShare
ReportReport
Posted on by 6
I set up a goal for a user, I am the Goal Manager. Record set for Rollup is All. Rollup query has one condition, a Custom User Lookup field = Current user.
 
Entity = Opportunity

I do not want to rollup records that are owned by the Goal Owner but based on a rollup query.
 
When the user selects Recalculate, the actuals do not generate values for the user.
If I change the Manager to equal the Goal Owner, then recalculate, the actuals and the participating records match but I do not want the user to also be the Goal Manager.

What am I doing wrong?




I have the same question (0)
  • Verified answer
    Cui Hao Profile Picture
    Microsoft Employee on at
    Hi,

    I did a test as follows:
    1.I set Goal Owner and Manager as different roles for the test.


    2. This is a custom lookup field = current user.


    3. The entity is set to the Opportunity entity with the following field conditions.

    After testing I found that the customer users field only calculates the value if it is the same as Manager.
    If you use the /Equals current user/ condition, you can only display the calculated value if it equals manager.
    If you create a goal, the goal record is shared with the goal owner and he gains read and append access to the goal. Those are the only two permissions the goal owner has.The goal manager has recalculation authority.
    This is my personal understanding, and I hope it will help you.


    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.If you have further questions, please feel free to contact me.

    Best regards,
    Cui Hao

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 213 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 71

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans