I having a column called 2011 prjections vs actuals.It has basically values in percentages.If the values is negative then it should in green color .if its 1-5 % its yellow and all the percentage greater than 5 % should be in red.Howdo i do this using the conditional variables. which one should I use? and how do i do it?
It wil be great if somebody can help me? still suffering wit a deliverable.
In Report Studio, from the menu select Tools, then "Manage Conditional Styles"
Also have a read of
http://www.ibm.com/developerworks/data/library/cognos/reporting/dynamic_report_design/page553.html?ca=drs-
https://www.packtpub.com/sites/default/files/0349-chapter-2-advanced-reportauthoring.pdf
Hope this helps
Cheers
Peter B
expression
case
when 2011 prvsactual<=0.00 then 'green'
when 2011 prvsactual between 0.01 and 0.05 then 'Yellow'
when 2011 prvsactual>0.05 then 'Red'
end
Use the above expression and apply general conditional formating.
Thank you all,IT really helped me ;D