Display string

[Former Member]

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

[abhilash_kumar · Accepted solution]

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