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
Click on New Calculated Item
In Display Label, enter a name
Select the Sum function
Select Values From Org Level 1
Select a few Organizations
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
Click on New Calculated Item
In Display Label, enter a name
Select the Custom Formula function
In Selected Values, enter the formula : sum($1,$2,$3)
Click Ok and the Calculated Item will appear in the table (it will sum the first 3 rows)