COGNOiSe.com - The IBM Cognos Community

Hi all

Is there any way to join my period Parameter value and concatenating it with ' YTD'

the reason for this is because I wish to see Period 6 in one column and then Period 6 YTD in another, my dropdown allows the user to select Period 1-6 but I would like to create a data item called 6 YTD from the selection.

thanks all

Quote from: Chunk on 02 Dec 2014 03:50:21 PM
Hi all

Is there any way to join my period Parameter value and concatenating it with ' YTD'

the reason for this is because I wish to see Period 6 in one column and then Period 6 YTD in another, my dropdown allows the user to select Period 1-6 but I would like to create a data item called 6 YTD from the selection.

thanks all

Hi Chunk,

How about making a new data item and doing the concatenation, for e.g. you can create a new data item and write the following expression.

?Your parameter name?+' '+'YTD'

in the value prompt properties, there is an option for 'use value' and 'display value'. in the use value you can use the orignal data item and in the display value you can use the new data item.

i hope this helps. Do update me if you need any help.

Regards