3 Replies Latest reply on Apr 13, 2015 7:24 AM by 2923996

    How to supress zero values in a union report in obiee11g?

    2923996

      I have a union report using two subject areas in obiee 11g.

      I have  added the price column from the first sector area and dummy column from the second sector area.

      I have  added the parity column from the second sector area and dummy column from the first sector area.

      Then i added result column to divide them.

      I need to calculate the avarage for each column, but because of the dummy columns that return zero, the calculation is wrong.