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 :
Microsoft Dynamics GP (Archived)

Management Reporter percentage ratio problem with multiple financial dimensions

(0) ShareShare
ReportReport
Posted on by 495

I am trying to get a percentage ratio across three separate companies on a consolidated financial statement.  When I create my TOT rows and my CAL rows the number come out correctly.  But when I go to create my percentage row it calculates all of the company percentages separately and then add them together giving me (591.62%)  The percentage is suppose to be closer to 54%.  Any help with this would be greatly appreciated.

Thanks,

Steve M

*This post is locked for comments

I have the same question (0)
  • Verified answer
    sueconrod Profile Picture
    337 on at

    If you bring up your Report Definitions and go to the tab on your report that says setting, you can go to:

    CALCULATION PRIORITY

    Try and change this from

    Perform column calculation first and then row

    to

    perform row calculation and then column

    This

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans