This is downloadable chapter 8 "Using Column Formulas with Text Data " of book "Oracle CRM On Demand Reporting".

Please see book description below.

Your One-Stop Guide to Oracle CRM On Demand Reporting

Plan, build, and distribute data-rich business intelligence reports with ease. Oracle CRM On Demand Reporting details the entire report-building process and explains how to use the powerful features available in Answers On Demand to create and share comprehensive, integrated reports. The book includes proven strategies for report design and development, real-world examples, formatting tips, advanced reporting techniques, and sample formulas. Convert disparate corporate data into actionable business intelligence with help from this detailed guide.

Maximize the features of Answers On DemandStrategically plan your reportsFormat, sort, filter, and modify report dataUse column formulas with numeric, date and time, and text dataApply logic and transform data with column formulasFormat report title and table viewsAdd charts, graphs, pivot tables, filter prompts, and interactivity to reportsConfigure advanced views and create custom dashboardsManage reports and control accessPlease find at attachment for chapter 8 of this book.