Using Formulas

Formulas are expressions, by which data is transformed into another type.

Formula Structure

Any formula starts with an equality sign (=):

  1. Built-in function.

  2. Links to the cells: A1 and B2 return values contained in corresponding cells.

  3. Constants: numeric or text values entered directly to a formula, for example, 2 and 20.

  4. Operation characters: "+" is an addition character and "*" is a multiplication character.

It can be used in formula:

Constants

Operators

Cell references

A1 and R1C1 reference styles

Absolute and relative references

Built-in functions

Fore and Fore.NET functions connected to report

Custom Functions

Functions that use the PrxReport and MetabaseClass classes

Examples:

=12*B2+C3/2

=Abs(A0)

=Sum(K10:K15)+20

=B0+"Sheet2"!A1

NOTE. When exporting to the *.xls format, remember that Microsoft Excel does not support all functions. There are certain restrictions for function export.

Operations with Formulas

The following operations are available when working with formulas:

Create a formula

Edit formula

Set up cell indication

Features of Formulas Use in the Web Application

The web application allows for only for creating and editing a formula directly in report data area cells. One can use constants, operators and cell references in a formula using manual cell address input.

to create, edit and view a formula, double-click the formula cell:

See also:

Working with Report Sheet | Formula Bar | Function Wizard | Correcting Links in Formulas