This discussion is archived
2 Replies Latest reply: Jun 27, 2013 2:16 PM by 980622 RSS

Calculate Variance Doesn't Work

980622 Newbie
Currently Being Moderated

Hi,

 

I am just trying to calculate the variance using new calculated item from OBIEE 11G answers.

 

Calculation: Col 4    Col5

                   6          7

 

Syntax: $5 - $4

 

Output: -6

 

Expectation: 1

 

Any inputs appreciated.

 

Thanks

Harry

Legend

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