cancel
Showing results for 
Search instead for 
Did you mean: 

CASE Statement for Universe Object getting parsing failed

Former Member
0 Kudos

Hi Experts,

I am getting parsing failed for the following case statement when i am trying to create a new object. Please kinldy help me out on this issue.

CASE WHEN {fn month(IDENSLABBHDLY.FullDate)}>= 6 and {fn year(IDENSLABBHDLY.FullDate)} = 2011 or {fn year(IDENSLABBHDLY.FullDate)} > 2011 THEN [IDENSLABBHDLY.Dy_Calls]-[IDENSLABBHDLY.Dy_HO_CHAN_ALLOC] ELSE [IDENSLABBHDLY.Dy_Calls] END

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks it is working fine.

Former Member
0 Kudos

What type of database is it?

Standard syntax would be:

CASE WHEN {fn month(IDENSLABBHDLY.FullDate)}>= 6 and {fn year(IDENSLABBHDLY.FullDate)} = 2011 or {fn year(IDENSLABBHDLY.FullDate)} > 2011 THEN table.Dy_HO_CHAN_ALLOC ELSE table.Dy_Calls END

Have you tried using your code in a SQL client?

Former Member
0 Kudos

Thank you for your support it is parsing fine.