Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

rows and columns with zero values - hide in Management Reporter?

Posted on by Microsoft Employee

I have a budget to actual income statement that is driving me crazy!  I want to hide rows and columns that have zero values but the CBR calc is returning 100% in the variance column so does not hide.  Any work arounds?  An if then statement in the row def maybe? 

Any help is appreciated!

Rose

Categories:
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: rows and columns with zero values - hide in Management Reporter?

    I just had another option in mind .

    On the row definition, you may check the print control as there is an option to suppress the row if all zeros.

    1122.123.png

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: rows and columns with zero values - hide in Management Reporter?

    On the report definition, there are options to handle zero values

    6180.12.png

    There is a detailed article on the Financial Reporting blog which illustrate how to manage zero-values on your report

    Please never hesitate to share any further inquiries,

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,246 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans