How to Hide a Complete section when no values and How to Replace zero values with Null values

[Former Member]

Hi,

My webi Report is based on many sections(section is applied on Cost Centres) at present in my report for some of the measure column vlaues are showing '0's and for some measure columns showing empty(which means Null).

But my user's wants

1-->Hide the section when that section doesn't have any values for all the columns and their totals.

2-->Where ever the section values are showing 0's it should replace with Null values(which means it should display empty in place of 0's).

My Webi Reports are created on top of BICS Connection.

Appreciate all your inputs on this.

Thanks & Regards,

     Kumar V

[Former Member]

You can right click on the section you want to hide and go to Format Section.

There are multiple ways to hide a section, in the above case, below 2 options should work

Hide When Empty

Hide When following Formula is True - (based on formula on null values for the variable)

For converting 0's to null, you can have a formula created - If([Cost Center] = 0;"";[Cost Center])

something similar to this.

Let me know if this helps.