Creating Nested calculated field

I am with BMC smart reporting and I belive they have removed the freehand SQL.

but here is a screen shot.

HI Corey,

From what I can see, you do not need the initial parenthesis before the original CASE.

Additionally, you are surrounding odd things in parentheses (specifically the highlighted portion in your screen-shot). I would write like:

CASE WHEN ((A=1 OR A=2) AND (B=1 OR B=2)) THEN ___________ END

Are you able to get this to work in queries against the database directly (if you have access to it)

Regards,

Nathan

I am new to (case) statements, I used (if elseif) statements before Business Objects software and got it to work. I am trying to buckets tickets in certain categories.

but basically in that statement I want to capture all tickets that are not resolved and are from level 1 and assigned to a specific group to have a particular category, then I want all tickets that are not resolved and are from level 1 and are not assigned to a particular group to be in a category, then all other tickets will be from level 2.

Hi Corey,

While I cannot speak to your exact use case, the problem seems to be specifically in your WHEN clauses specifically (aka IF). When you write a case statement simple logic such as a single and/or, you will not need any parenthesis:

CASE WHEN A=1 OR A=2 THEN B END

This would be the same as

IF (a=1 || a=2){
   B
 } 

If you want to nest this logic, then you will need to user parentheses:

CASE WHEN (A=1 OR A=2) AND B=1 THEN C

Let me know if this makes sense.

Regards,

Nathan

ok no problem, no luck as of now,