This discussion is archived
0 Replies Latest reply: Jan 8, 2013 10:58 PM by 947349 RSS

Aggregation displays wrong value

947349 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points