WEBI Hide Rows

[former_member336161]

Hello,

I am trying to hide rows conditionally in a WEBI report v4.1. The highlighted row below is a sample of what I need to hide. If structure row is 'Estimated Savings' and measures are blank/0, then hide the row. My variable is the column on the right and displays Hide so seems to be working.

But the measure results display UNAVAILABLE when adding a filter to the table using my HideRow variable.

T

I have researched the forums and found 1 similar issue but gives no solution.

Please advise.

Thanks,

Roseanne

[jyothirmayee_s]

Hi,

Try Inlist() than = sign.

Also, if you only want to hide when measure is 0 or null then it would be good practice to have variable defined only to hide null or Zeros.

If([A]=0 or is null([A])) then Hide;display

Thanks,

Jothi

[former_member336161]

Thanks for responding.

I do want to hide if the measures are 0 or null but only for certain rows in the structure.

I tried inlist as well and still getting UNAVAILABLE.

[Former Member]

Why not use the format table options to hide the blank/0 rows?

[former_member309630]

Hi Roseanne,

Why can't you try 0 or 1 instead of using Hide and Display and make it as a measure and try.

Thanks,

Durga

[former_member336161]

Thanks much for your response.

To keep it simple, I created the variable as this and receiving same results. The filter is on the table (vertical).

[amitrathi239]

try to create your variable as measure and see.