This discussion is archived
11 Replies Latest reply: Feb 28, 2013 5:16 PM by ZFMA86 RSS

SUM(CASE WHEN statement is not returning proper result.

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

Legend

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