Skip to Content
avatar image
Former Member

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

Untitled.png (134.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 05, 2015 at 10:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded