0 Replies Latest reply: Jan 9, 2013 12:58 AM by 947349 RSS

    Aggregation displays wrong value

    947349
      Hi,

      OBIEE 11.1.1.5

      I have 3 columns, Column1,Column2,column3

      based on 3 columns,I have done agregation like below

      a=column1*column3 (result comes correct)
      b=column2*column3 (result comes correct)
      c=a/b (result wrong)

      Something like this i have used : (column1*column3)/(column2*column3)

      can i know why it comes wrong