Rename /replace different vaues on of one column in a single calculated column SAP SF Story Report.

[prakharvarshn]

Hello Everyone,

I am using SAP SF story reporting to prepare the report

Given below is the data table

All the columns i am getting from the system except Field_ID_Competency_IDwhich is a calculated column (by cocating ) to create unique values. What I want to do is to hard code the values in the Field_IDCompetency_ID Column or you can say I want to renmae/replace the values with ohter values.

Like ele_01010316 be renamed as "Strength Area Peer Comment" and ele_11010316 be renamed as "Strength Area Manager Comment" and like wise in one calculated column.

The final output table should be like this

[MikeC]

Hi

I was looking for help on using the Replace formula in Stories and came across your question. As you haven't had a response I thought I would offer mine.

I'm new to Stories but I'm assuming you can't put multiple formulas like the below together so I'm guessing you would need to have 2 separate calc. columns for the 2 examples you gave. If you have hundreds to change then this might not be practical.

The first calculated field would be the first one below. That would convert "ele_01010316" to "Strength Area Peer Comment". The second one would convert "ele_11010316 to "Strength Area Manager Comment".

First Calculated Column name is SAPC and formula is Replace (Field_ID_Competency_ID, "ele_01010316" , "Strength Area Peer Comment")

Second Calculated Column name might be SAMC and formula is Replace (Field_ID_Competency_ID, "ele_11010316" , "Strength Area Manager Comment")

Then a third calculated column called Section would simply check to see which of the 2 above contains the answer and just return that one. Formulas would be:-

If ([SAPC]>"" ,[SAPC],If([SAMC]>"",[SAMC]",""))

Hope it helps.

Mike