Avatar of shieldsco
shieldsco
Flag for United States of America

asked on 

Case When Syntax

I using the following case when statement and receive a parsing error.

Case When
[ALJ Appeal Lifecycle Star].[Lead Adjudicator].[Employee Full Name] ='Hohn, Christian'
And [ALJ Appeal Lifecycle Star].[Decision Letter Mailed Date].[Decision Letter Mailed Date] Between 2019-10-01 and 2019-12-09
Then
[ALJ Appeal Lifecycle Star].[ALJ Appeal Lifecycle FACT].[ALJ Child Appeal Count] = 0
Else
[ALJ Appeal Lifecycle Star].[ALJ Appeal Lifecycle FACT].[ALJ Child Appeal Count]
End

Open in new window

SQL* Cognos

Avatar of undefined
Last Comment
shieldsco

8/22/2022 - Mon