11 Replies Latest reply on Mar 1, 2013 1:16 AM by ZFMA86

    SUM(CASE WHEN statement is not returning proper result.

      Hi Folks,

      I'm an end-user on OBIEE 11g creating a custom analysis. I'm trying to SUM a particular case statement: SUM(CASE WHEN "MyMeasureColumn.Here" LIKE '%~25~%' OR "MyMeasureColumn.Here" LIKE '%~26~%' OR "MyMeasureColumn.Here" LIKE '%~27~%' OR "MyMeasureColumn.Here" LIKE '%~28~%' THEN 1 ELSE 0 END)

      The result should be about 6,700 however I am getting only 1,900. Any ideas?