Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Report Writer
Finance | Project Operations, Human Resources, ...
Unanswered

Management Report Writer

(0) ShareShare
ReportReport
Posted on by TheWhiz 15

Percentages are calculating 0% when drilling down to the account level for calculating percentage of gross sales  Is there any way to calculate the percentages?  See below for an example.

Thanks muchly for your help.

Thanks,

Ellen

3295-15-03 Tuitiion-Spring Hill-Coding 15,319 0.00%
3295-15-06 Tuition-Spring Hill-Dental Assistant 31,710 0.00%
3295-15-07 Tuition-Spring Hill-Medical Assistant 22,977 0.00%
3295-15-20 Tuition-Spring Hill-LPN Program 242,927 0.00%
3295-15-21 Tuition-Springhill-RN 56,765 0.00%
3295-15-25 Tuition-Spring Hill-LMR (29,293) 0.00%
   
Total Tuition 340,405 70.84%
Categories:
Microsoft Dynamics GP
  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Report Writer

    How is the percentage column formatted?  Is it a simple calculation like B/C, or is it a CBR calculation like B/BASEROW?

    If it's a CBR calculation, those don't show percentages at the detail level.  You'll see the total, but the CBR is not calculated on the individual account detail lines.  

    If you have a calculation like B/C, then that will show percentages on each account detail line.  

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Management Report Writer

    Hi Ellen,

    in order to understand what you're trying to achieve, could you share screen shots of the Row & column definitions of your report ? MR 2012 is kind of a little bit like Excel with formulas in the cells, but sometimes the devil is in the details..

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans