Is there a way to exclude a tab in a book if that tab has no data?
I have a cost center loop added to a book. The loop includes all cost centers, although I know some cost centers have no data. I want to make sure we aren't excluding any cost centers in the event an old cost center is used. I'm trying to ensure the report is complete. However, adding all cost centers to the loop results in many completely blank tabs. Is there a way to suppress these tabs or exclude them from the output?
Hi cogburnml: your request makes total sense and it feels like there should be an easy way to do this! I can think of two ways (listed below), but I hope someone from the community has an easier solution, as my brain created a convoluted route to achieve this
Option 1 (More Difficult):
I did a basic test of the above and it did work, but did not include much for parameterization of scenario/time/entity dimensions. Obviously, it has many steps (Parameter, BR, CV) which increases risk that something doesn't work right.
Option 2 (Easier - but not quite working)
The problem with the above is that the If Statement does not properly compare a value to 0. Meaning, (0 = 0) fails [does not evaluate to true], as does (0 <> 0) [incorrectly validates to true]. Interestingly, (Test = Test) evaluates correctly. @ChristianW is this a bug with (0 = 0) not working in a Report Book IF Statement?
Like I mentioned, hopefully someone has an idea that is not so convoluted.
Does anyone have a working example of this? I'm having the same issue. The cube view in the book has many accounts so if any of those accounts have balances I need them to show in the book but I'm looking to exclude the tabs that are completely blank.
Hi LisaS: this question was recently asked again and I shared my current (working) solution. You'll find it here: