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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

MR Reports column calculations

(0) ShareShare
ReportReport
Posted on by

Dear Microsoft Finance Community

You can see in the Management Reporter report that the two columns for revenue do not add up.  They um to a credit.

Any suggestions on how I can adjust MR to correct tis issue in.

Regards,

pastedimage1628116656811v4.png

pastedimage1628116601095v3.png

I have the same question (0)
  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    Hi Michael,

    Can you please share the formula calculation? Along with this row definition.

    It can be due to some Sign on the row definition or column

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Michael,

    I would recommend that you have a look at your variance calculation specification.

    Seems that you make use of the favorable/unfavorable XCR functionality.

    Please review this calculation and also check your calculation priority and whether row or column calculations are made first.

    The following documents might help:

    www.gpug.com/.../DownloadDocumentFile.ashx

    www.youtube.com/watch

    Best regards,

    Ludwig

  • Michael agostini Profile Picture
    on at

    Ludwig, I tied all these things.

    I just tried the cal priority again and it resolved the issue.

    Thank you as always!!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans