Formulas are useful for manipulating and computing data for your report. For example, you might want to calculate the difference between two currency amounts, or do more complicated things such as storing a certain value in a variable in order to use it later in your report.
Formulas are made up of one or more statements, each of which can contain fields, functions, operators, control structures, and/or constants. The last statement of a formula is the formula's return statement. Note that this statement must return a value, not a range or array.
Formulas in i-net Clear Reports must either be written in Basic syntax, which is a syntax very similar to Microsoft Visual Basic, or in Crystal syntax, a syntax similar to the Crystal Reports formula syntax.
A description of the error handling if errors occur in the various formula types can be found here.