Database Reference
In-Depth Information
22.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Data Item
object into the
Data Items
pane.
The Data Item Expression dialog box is displayed.
23.
Using items from the
Data Items
tab of the
Av a i l a b l e C o m p o n e n t s
pane, add the fol-
lowing expression in the
Expression Definition
pane:
[Return quantity] / [Quantity]
24.
Va l i d a t e t h e e x p r e s s i o n a n d c l i c k
OK
to close the dialog box.
25.
In the
Properties
pane, change the
Name
property to
Return/Ship Ratio
and change
the
Aggregate Function
property to
Calculated
.
26.
From the
Run
menu, select
View Tabular Data
to test your query.
27.
Click
OK
to dismiss the warning message and, when prompted, expand
Employee by
region
and select
Americas
.
Match your results to those shown in Figure 2.13.
28.
Close
IBM Cognos Viewer
to return to your report design.
Figure 2.13
Returned/shipped ratio query results