If Condition for a Section title in a Webi Report

[Former Member]

Hi all,

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])

[Former Member · Accepted solution]

Never mind.

Found the solution

=If(IsNull([Committee Name]) ; "X-No Committe Assigned";[Committee Name])

this worked