WHEN condition on a couple of values

Hi,

I’d like to group a set of values in a WHEN condition, as follows

CASE [Issue Type].CurrentMember.Name
WHEN ‘Type1’ THEN
WHEN ‘Type2’ THEN

WHEN ‘Type1’, ‘Type2’, …

Is there a way to do so or similar?

thanks
alexandre

Hi @anitu ,

You can try the OR operator. See an example below:

CASE WHEN [Issue Type].CurrentMember.Name = 'Story'
OR [Issue Type].CurrentMember.Name = 'Bug'
OR [Issue Type].CurrentMember.Name = 'Task'
THEN "Something"
ELSE "Other value"
END

And a screenshot from a report:

Best,
Roberts // support@eazybi.com

Thank you Roberts!
very much appreciated!

1 Like