Difference between revisions of "CALC()"
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to perform report calculation | Function to perform report calculation | ||
| Line 25: | Line 23: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Numeric Data]] | [[Category:Numeric Data]] | ||
[[Category:Numeric Data Functions]] | [[Category:Numeric Data Functions]] | ||
Latest revision as of 16:08, 27 November 2009
Purpose
Function to perform report calculation
Syntax
CALC(<memvar>, <expN>)
See Also
Description
The CALC() function evaluates the specified numeric expression <expN>, places the result in the designated accumulator <memvar>. The return value of the CALC() function is the result of the numeric expression <expN>. This function is only valid in report format <.frm> files. The CALC() function should be used in conjunction with the ACC() function. There are 20 accumulators available, which are cleared to zero at the start of the report (REPORT FORM command). The first 10 accumulators are cleared on each sub-total break, and the last 10 are carried through to the end of the report. These accumulators are useful for providing horizontal totaling facilities.
Example
calc(1, acc(1) + order_value)
Products
Recital Server, Recital
