Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Display string

Hi All,

I have a crosstab report having columns as Activity id and summaries as emprating.

Here the values for activity id are 1,2, 3.

And also the summaries values as 1,2,3.

But I need to show a text based on values .

If Activity id is 1 then I need to show Customer First

If Activity id is 2 then I need to show Develop & Manage Self

If Activity id is 3 then 3 need to show Plan & Organise

And

if the summary(rating values) is 1 then Excellent

summary(rating values) is 2 then Achieved

summary(rating values) is 3 then Poor

Below is my screenshot for report

Tags:
Former Member
replied

Hi Divya,

You can even do this without a 'Display String' formula.

Create a formula with this code:

If {Activity_ID} = 1 then "Customer First"

else If {Activity_ID} = 2 then "Develop & Manage Self"

else if If {Activity_ID} = 3 then "Plan & Organise"


Use this as the 'Row' of the crosstab (if you have one), otherwise just group on this formula if that's where the Activity IDs are.


For the Summaries, you can create a similar formula:


If {Summary_Rating} = 1 then "Excellent"

else If {Summary_Rating} = 2 then "Achieved"

else if If {Summary_Rating} = 3 then "Poor"


Add this formula as the 'Summarized Field'.


If you wish to use a Display String formula instead, then just right-click the fiel > Format Field > Display String. E.g: Code is:


If CurrentFieldValue = 1 then 'Customer First'

else If CurrentFieldValue = 2 then 'Develop & Manage Self'

else If CurrentFieldValue = 3 then 'Plan & Organise'


-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question