Examples of Calculated Items

The examples and explanations in this section assume that you have a basic understanding of SQL statements and their syntax. The syntax shown in these examples applies to the Custom Formula function in the New Calculated Item dialog. The examples are hypothetical. Not all possible calculated items are shown.

Example 1 - Say you have a report with Org Level 1 and # Requisitions and you generate the results

1. Click on New Calculated Item

2. In Display Label, enter a name

3. Select the Sum function

4. Select Values From Org Level 1

5. Select a few Organizations

6. Click Ok and the Calculated Item will appear in the table

Example 2 - Say you have a report with Org Level 1 and # Requisitions and you generate the results

1. Click on New Calculated Item

2. In Display Label, enter a name

3. Select the Custom Formula function

4. In Selected Values, enter the formula : sum($1,$2,$3)

5. Click Ok and the Calculated Item will appear in the table (it will sum the first 3 rows)