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
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,246
Super User 2024 Season 2
#2
Martin Dráb
228,041
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (