Download BusinessObjects User's Guide

Transcript
List of Examples
Displaying total revenue as a table title ........................................................................................304
Converting to euros: six-digit conversion rates ...........................................................................305
Add US dollars to the euro conversion list ..................................................................................310
Triangulation: Converting between EMU-compliant currencies ..............................................311
Calculating a running total .............................................................................................................319
Highlighting above average margin ..............................................................................................323
Group quarters to display revenue per semester ........................................................................325
How can I rank cities according to sales revenue? ......................................................................333
Calculating a 3-week rolling average ............................................................................................335
Combining first and last names in a single cell ...........................................................................336
Combining text and data in a single cell .......................................................................................337
Combining text and numbers in a single cell ...............................................................................338
Combining text and dates in a single cell .....................................................................................338
Comparing yearly margin growth using the Where function ...................................................339
Revenue per region per year, and revenue per region ...............................................................343
Calculating total revenue for two years ........................................................................................344
A report containing aggregations in different contexts ..............................................................346
The extended syntax of an aggregate formula .............................................................................348
Calculating the number of cities per region .................................................................................350
Calculating the minimum revenue per city for each region ......................................................351
A formula containing input and output contexts ........................................................................352
Calculating running total revenue per country ...........................................................................354
Using ForEach and ForAll ...............................................................................................................358
Calculating a grand total by using the Report keyword ............................................................365
The formula BusinessObjects writes for a simple calculation ...................................................367
#COMPUTATION resulting from a running sum with a reset context ...................................378
#COMPUTATION caused by a conditional formula in a break footer ....................................380
#MULTIVALUE in an aggregation ................................................................................................383
#MULTIVALUE in a break footer ..................................................................................................385
#MULTIVALUE in a section containing Name and Address ....................................................387
Solving #IERR by turning part of a formula into a variable ......................................................396
Part IV Working with Charts
Re-organizing data on chart axes in 2-D charts ...........................................................................413
Showing multiple lines on a line chart ..........................................................................................414
Re-organizing data on chart axes in 3-D charts ...........................................................................415
Adjusting the plot area to the chart size - before and after ........................................................427
Adjusting scaling in a master/detail report .................................................................................440
Comparing revenue and quantity sold in a chart ........................................................................451
xii BusinessObjects User’s Guide