If

[psenthilbtech]

Hi

Below is my requirement

How to handle this is ?

if Open, below condition 
Caseclosedyear is null
Caseraised year not null
Case status <> 69

if Closed, below condition 
Caseclosedyear not null
Case status <> 69

if Cancelled, below condition 
Caseraisedyear not null
Case status =69

Thanks

[JordyWegman]

Hi,

Try this:

IF( isnull(Caseclosedyear) and not isnull([Caseraised year]) and [Case status] <> 69, 'Open',
   IF( not isnull([Caseraised year]) and [Case status] <> 69, 'Closed',
        IF(  not isnull([Caseraised year]) and [Case status] = 69, 'Cancelled','Other status')
      )
)

Jordy

Climber