Print Page - List Column values display like 'excellent' and 'poor'

Title: List Column values display like 'excellent' and 'poor'
Post by: Revathi_M on 28 Oct 2014 09:13:34 AM

I have one List in column values display 1 to 100
here i need less 30 I need Display Label as"Poor"
30 to 70 "very Good"
more than 70 display "excelent"

I am traied "conditional style" it display only color not label like "good" "poor" "excellent"

I am need same column or new column

2nd question : how to add new column in list

thanks

Title: Re: List Column values display like 'excellent' and 'poor'
Post by: BigChris on 28 Oct 2014 09:52:16 AM

Hi Revathi_M,

In your report drag in a new Query Calculation and give it a name. For your calculation you then want something like

Code Select


Case 
  When [Date Item] between 0 and 29 then 'Poor'
  When [Data Item] between 30 and 70 then 'Very Good'
  When [Data Item] between 71 and 100 then 'Excellent'
Else 'Out of Range'
END

You can then apply you conditional format to your new field.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Revathi_M on 28 Oct 2014 09:13:34 AM