2 Replies Latest reply: Jun 27, 2013 4:16 PM by 980622 RSS

    Calculate Variance Doesn't Work

    980622

      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