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,
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!