Display column values based on object values

[former_member672670]

Hi All,

I want to display values of certain columns based on the value of an object in my Webi report.

My columns are - ID and Name. My object name is Status that has values of 'Y' & 'N'. If Status = 'Y', I want to display values for both the ID and Name columns. If Status = 'N', I only want to display values for the ID column, but no values for the Name column i.e. blank. I am not sure how I would incorporate the logic in a report variable with an IF statement to display values for multiple columns. Any ideas?

[mhmohammed]

Hi Jeewan,

Use the ID column as is in the table, but for the Name column, create a variable as v_Name with the below formula, and use that variable in the table.

=If([Status]="Y") Then [Name]
Elseif([Status]="N") Then ""

Thanks,
Mahboob Mohammed

[former_member672670]

I tried the solution, but it only return rows where Status = "Y". There are other rows that have Status of "N" or "", but those are not displayed in the report. There are other block level filters applied on the report, so I'm not sure if that might be an issue.