Skip to Content
avatar image
Former Member

HOW TO HIDE A ROW ON WEBI REPORT WITH 0 AND NULL VALUES

Hi gurus,

I am doing a webi report, the report have 3 columns and in some rows the report has in column 1 NO VALUE (it means the cell is empty or null) in column 2 0 and in column 3 0 again. For me 0 or NULL is the same and I need to hide or delete these rows but I don't know how.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 27, 2011 at 08:51 PM

    Hi Jorge

    Another option is to edit the query, drag the measure to the query filter and use the "is not null" operator and "not equal" or greater than" 0 for it.

    This will filter the result from nulls and zeros.

    Best Regards

    Erick

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Padawan Girl,

      Your solution works fine, I had something similar in mind, but your suggestion was better, I'll give you points for you answer.

      Thanks every one for your suggestions.

      Best Regards

  • avatar image
    Former Member
    Jan 27, 2011 at 05:06 AM

    Hi

    Create a variable for each column with this formula =If([Column1] <>0) Then([Column1]) in Web Intelligence.

    In Universe create an object with condition if column is not equal to 0 or null then display column.

    Edited by: Swarna K on Jan 27, 2011 6:06 AM

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 27, 2011 at 06:00 AM

    why you dont apply a quick report filter to hide ZERO and NULL values?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2014 at 09:53 AM

    To be more appropriate we sholud use absloute function e.g.

    if  Dim1 =(100)

       Dim2 =(-50)

       Dim3  =(-50)

    simple sum of above will be "0". And row will be hidden.

    To avoid such condition we should use absolute function

    =If ( Sum(abs([Dimension1])+abs([Dimension2])+abs([Dimension3])) = 0 ; "Hide" ; "Show" )

    --Aniket

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2011 at 06:26 AM

    Hi,

    This may help for you

    Here we can resolve the problem by using alerter

    1.click the alerter button from the Report

    2. In this click create new alerter

    3. The alerter window display

    4. In this sub alerter field check the formula

    5. It opens sub alerter window

    6. click fx, left side of the window

    7. It display formula editor window

    8. then write the formula column=0 then click ok

    9. click format button, select color:default then click ok

    10.this alerter added to available alerters window.

    11. select the column which you want to apply,and click alerter from report then check it.

    12. the record which u don't want to delete.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jorge,

      I am sort of remembering dealing with a similar problem I had..... Try reformatting the columns that show 0's to be blanks. That might work.

  • avatar image
    Former Member
    Jan 27, 2011 at 10:18 AM

    Hi,

    In the query properties ---Rows/colums tab ---supress Zeros select active --- select third option in the Table delete the row if all are zeros....

    thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I had tried activating the supress cero option on query designer, but it didn't work.

      Edited by: Jorge Arjona on Jan 27, 2011 4:19 PM

  • avatar image
    Former Member
    Jan 27, 2011 at 12:03 PM

    we can not delete or remove particular column field. there is only possible remove row or column or table.

    there are only two methods for manuplating a report

    1) Restriction using any filter

    2) using formulas(functions).

    Report filter--->we doesn't use this fiter for measure objects it is use only for detail and dimension objects

    Query filter: drag the object -


    >not eual to-----> 0

    so you can rectify " 0 or NULL " values on your report.

    formulas: use the formula from formula editor dailog box and restrict your data.

    and one more is using alerts:

    the alert option hide the data like "0 or NULL" to empty when you apply the font color is default..

    but when you use calculation---> average the 0 is also counted.

    just the alert like mask of the value..

    All the best..

    Add comment
    10|10000 characters needed characters exceeded