Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) rows and columns with ...

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

Like (0) Share

Report

Posted on 22 Jun 2015 18:09:10 by Community Member

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

*This post is locked for comments

All responses (2)

Answers (0)

Mahmoud Saadi 32,738 on 23 Jun 2015 at 09:33:09

Like (0)

Report

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.
Suggested answer

Mahmoud Saadi 32,738 on 23 Jun 2015 at 09:29:29

Like (0)

Report

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

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

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,