Hiow to use CASE statement for a checkbox field?

Questions & Answers
,
1

Hi team,

I have a checkbox field (Milestone 1 checklist) that contains certains options. I’m creating a report using CASE When/Then statements. I’m not getting correct report. It’s partially correct.
I want-

  1. When the option- “Survey Set Up completed (all local customizations provided where applicable)” is checked (no matter if other options are checked or not), then it should say ‘Completed’.
  2. When no option is checked, it should say ‘Not Started’.
  3. When it’s neither the 1st option nor it’s None, then it should say ‘In Progress’

Below is the calculated member I created:

CASE
WHEN
([Measures].[Issue Milestone 1 checklist]) MATCHES ".*Survey Set Up completed (all local customizations provided where applicable).*" 
THEN 'Completed'
WHEN
([Measures].[Issue Milestone 1 checklist]) = '(none)'
THEN 'Not Started'
WHEN
([Measures].[Issue Milestone 1 checklist]) <> "Survey Set Up completed (all local customizations provided where applicable)"
AND
([Measures].[Issue Milestone 1 checklist]) <> '(none)'
THEN 'Started'
 END
2

Hi,

The CASE statement can have the ELSE branch, which seems to cover your case.

I tried the following code in my test environment:

CASE
WHEN
[Measures].[Issue Some checkbox field] MATCHES ".*Second option.*" 
THEN 'Completed'
WHEN
[Measures].[Issue Some checkbox field] = '(none)'
THEN 'Not Started'
ELSE
'In Progress'
 END

image
image1264×808 70.6 KB

Kindly,
Janis, eazyBI support