Case statement error in report studio 8.4

[UseCog]

Hi,

I have tried a case statement but got the following error.


QE-DEF-0459 CCL Exception
QE-DEF-0260 Parsing error.....

My case statement as follows. This is written inside a set expression. Also the parameter ?pstyle? contatins static values from 1 to 5.

CASE
WHEN ?pstyle?= 2 THEN periodsToDate ([Package].[Calendar].[Calendar].[Month], [Selected Week])
WHEN ?pstyle?= 3 THEN periodsToDate ([package].[Calendar].[Calendar].[Quarter], [Selected Week])
WHEN ?pstyle?= 4 THEN periodsToDate ([package].[Calendar].[Calendar].[Year], [Selected Week])
ELSE  [Selected Week])
END
Note: my source is a cube

Can anybody help me for this

Many thanks,
UG

[abu_a]

Hi

In the else part of your statement you seem to have a closed parenthesis but no open parenthesis. This may not solve your problem but it will help you to close in on it.

Hope this helps
Abu