3 Replies Latest reply on Nov 13, 2015 5:35 AM by Ibag

    Cannot use perform divison calculation in OBIEE 11g

    990854

      Hello. I am trying to divide to sets of numbers but the result is always 0.00. I switched the operator to multiply (*) and it shows results. I do not understand why divide '/' does not work. See what I am doing below. Note: The numbers are NOT from a column in the database. I am manually keying the numbers with a CASE statement.

       

      (CASE "PayM"."DEPT" --> this represents the first total

      WHEN '01' THEN 1150

      WHEN '02' THEN 145

      WHEN '03' THEN 42

      WHEN '04' THEN 844

      END)

      /  --> I want to divide the first total by the SUM of the first and second total

      SUM(

      (CASE "PayM"."DEPT" --> this represents the first total again

      WHEN '01' THEN 1150

      WHEN '02' THEN 145

      WHEN '03' THEN 42

      WHEN '04' THEN 844

      END)

      + --> I am adding the second total to the first total

      (CASE "PayM"."DEPT" --> this represents the second total

      WHEN '01' THEN 1875

      WHEN '02' THEN 255

      WHEN '03' THEN 29

      WHEN '04' THEN 1380

      END))

       

      So for department 01 I expect: 1875 /  (1875 + 1150) = .62

       

      Le