I have a requirement in a WebI report (version 4.2) to display the string “N/A” if values are NULL or empty.
In table 1 there is a simple variable:
If(ISNULL([FIELD1]);"N/A";[FIELD1])
This works correctly.
In table 2 there is a table filter which correctly filters out all rows and returns an empty set in the table. The user wants to display “N/A” in the table instead of it being empty. When I try the formula above it returns nothing since there are no rows in the table. I can check the box ‘Hide when empty’ and hide the whole table but the user would like to see “N/A”. Any ideas on this?
I may be thinking of something in Excel, but I thought there was a way to display something instead of an empty table/block. Whatever it was, I never managed to get it to work correctly…
I think it was the ‘hide when following formula is true’ functionality.
Thanks for the idea, that worked. I set the table to hide when empty. Then I created a second table and hard-coded the string N/A in the first row. Next I set table 2 to hide when a formula (count([Field1]>0) is true.
Thinking back, it may have been something to do with graphs - I wanted to display a different graph format for a single team as opposed to several teams. (18 months ago now for a different employer…)
(BOB member since 2009-01-09)