Skip to Content
avatar image
Former Member

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


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 12, 2015 at 07:07 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded