14 Replies Latest reply on May 30, 2018 3:44 PM by Christian Berg

    Divide 2 Columns in Union Report

    Ebin Cherian

      Hi All,

       

      Oracle Business Intelligence 12.2.1.1.0.

       

      I am struggling to create a calculated column which perform division on Union.

      I need to create a calculated column to perform calculation Amt 1/ Amt 2.

      So far result is correct. Now I am going to add a Region column to both analysis and then exclude it in the pivot table layout. When I do that, Division result is not correct.

       

      How can I fix this issue ?

       

      Thanks

      Ebin