11 Replies Latest reply: Feb 28, 2013 7:16 PM by ZFMA86 RSS

    SUM(CASE WHEN statement is not returning proper result.

    ZFMA86
      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?