Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

If Condition for a Section title in a Webi Report

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
Former Member replied

Never mind.

Found the solution

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

this worked

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question