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
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.
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,
#1
André Arnaud de Cal...
291,661
Super User 2024 Season 2
#2
Martin Dráb
230,379
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
