06-29-2022 01:25 PM - last edited 2 weeks ago by JackLacava
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?
06-29-2022 04:47 PM
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.