If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Concatenating Prompt Value with String

Started by Chunk, 02 Dec 2014 03:50:21 PM

Previous topic - Next topic

Chunk

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



Raghuvir

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