Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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