I am trying to create YTD column in my report.
I have created a time dimension, which I use when I prompt user for a current period. The YTD value should be calculated based on this value.
My time dimension looks like this:
-UTC DATES
- YEAR
- QUARTER
- MONTH
- DAY
I use periodstodate to get the members for YTD
periodstodate([Model].[UTC DATES].[UTC DATES].[YEAR];[CURRENT_PERIOD])
[CURRENT_PERIOD] is the value obtained from tree prompt (param_TimePeriod)
The periodstodate seems to work just fine. If I choose 2007/April, it returns 2007/Jan, 2007/Feb, 2007/March, 2007/April.
But when I try to create a YTD_EURO column with IF-structure, It all fails with error message "Invalid to compare Sets in expression for a dataItem="YTD_EURO"".
[YTD_EURO]: IF ([Model].[UTC DATES].[UTC DATES] IN ([YTD])) THEN ([EURO]) ELSE (0)
Is there any one who could so me the correct direction in this situation.
application: report studio v8.3
I would like to create a prompt to include as a selection some of the calculated members, but it will not allow me to select the calc mems upon trying to create the prompt, in fact you cannot even see the calc mems at this stage, help pls,thx