Use of formulas makes it possible to automate processing data in your database. For example, your database stores prices for some goods and quantities of the goods. You may use the [Cost]*[Quantity] formula to calculate the total cost of the goods. You may use even more complicated formulas containing functions working with a set of records. For example, the repMathOp(|Cost|,|SimpleAverage|) function will calculate simple average of costs in the set of records that the edited report incorporates.

You can access Formula Editor in the following ways:

• Create a Mathematical Field on the form using Form Editor.
• Add a Formula Field into the report using Report Style Editor.
• Create a button with the Apply Formula to a Field action using Scripts.
• Create a mathematical variable.