Step 10 - Configure Formula Fields
Formula fields can be built from any field within the Database. Fields can be added, subtracted, multiplied or divided. Formula results can also be used in subsequent formulas.
In the following example, the results of Formula 3 are the beginning balance for the Formula 4 calculation.
Formula_03 | |||||
---|---|---|---|---|---|
ANNUAL_BUDGET | - | YTD_EXPENDITURE | * | YTD_COMMITMENT | |
Formula_04 | |||||
Formula_03 | * | ONE_HUNDRED | / | ANNUAL_BUDGET |
The Formulas Screen shows the Formulas/Calculations that were chosen in the Display Fields portion of the Field Selection Screen. These calculations can be edited if required for the desired report.