Define formulas to perform specific calculations on data forms. For example, you can create a formula for a column to calculate the variance between the multiple budget versions. To customize data forms and refine the data displayed, create formulas to perform these tasks:
Average values
Total values
Multiply values
Identify maximum and minimum values
Round values
Truncate values
Display the numeric or percent variance to compare values
Rank values in a range that you specify
For information, see “Data Forms and Formula Functions” in the Oracle Hyperion Planning Administrator's Guide.