Database Reference
In-Depth Information
Figure 8-24.
Using the right-click shortcut to create a computation
13.
Set
Computation Type
to
SQL Query (Return Single Value)
. All other
values should have defaults similar to those shown in
Figure 8-25
.
Click
Next
.
Figure 8-25.
Setting the computation type
14.
In the
Computation
text area, enter the following SQL statement (also
shown in
Figure 8-26
), and then click the
Create Computation
button:
SELECT
DECODE(status, 'CLOSED', closed,
open_or_pending) days_open
FROM
(
SELECT