This content has been marked as final. Show 3 replies
In column formula type
LEFT("Presentation Table Name"."Opportunity Type Code", 1) .
This will give you first character of the String value.
Thank you so much !! Could you pls teach me the formula type for the case below too?
Column Name : Campaign Code (No change)
Result of data :
Unspecified ---> Unspecified (No change)
JPFM1 ---> Japan Local 1
JPFM2 ---> Japan Local 2
JPFM3 ---> Japan Global 1
JPFM4 ---> Japan Others
CNPG1 ---> China Local 1
CNPG2 ---> China Local 2
CNPG3 ---> China Others
AUAR1 ---> Australia Local 1
AUAR2 ---> Australia Local 1
in such cases you'd better create a database table and map it in the repository, if you can.
Anyway, I think that what you are looking for is the Bin.
Go to the Criteria page of the request definition. Edit the formula of the column you want. Go to the "Bin" tab and create labels as you like.
If you want, you may look at what this generates in the formula tab of the column, afterwards.
Hope it helps.