If Condition for a Section title in a Webi Report
I have a requirement where I need to filter the records based on Section. Now I have created the report and enhanced by creating a section on require element.
I just noticed that few records are not assigned to this element hence displaying under a blank section after breaking the report into sections.
Now I want to insert a formula on the section title which says if the section title is null display No committee assigned else [Committee Name]
Syntax seems to be working but even after refreshing the report, I see the blank cell instead of the text I passed.
Please advice. Thank you in advance
here is my syntax
=If([Committe Name] = "Null";"X-No Committe Assigned" ; [Committe Name])
Found the solution
=If(IsNull([Committee Name]) ; "X-No Committe Assigned";[Committee Name])