Tuples in Case statement

Questions & Answers
,
1

Why can’t I use tuples in the THEN part of a CASE WHEN?
Pretty sure every time I do, I get an error like “Formula is not valid:
Internal error: Cannot deduce type of call to function ‘_CaseTest’”
Any work arounds other than creating a calculated member for the tuple and just calling that?
Thanks!!

2

Hi,

The easiest workaround is to wrap the tuple in the Val function:

CASE WHEN
 [Measures].[Count issues]>0
THEN
Val(
([Measures].[Issues created],
    [Issue Type].[Story])
)
END

Kindly,
Janis, eazyBI support