ACC()

From Recital Documentation Wiki
Revision as of 16:35, 25 November 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return report accumulator


Syntax

ACC()


See Also

CALC(), CREATE REPORT, IIF(), REPORT


Description

The ACC() function, which is only valid in report formats, returns the contents of the specified report accumulator. There are 20 accumulators available in a report format (.frm file). All accumulators are cleared to zero at the start of the report (REPORT FORM) command. Accumulators 1 to 10 are cleared after each sub-total break. This function is useful if used in conjunction with the CALC() function which determines how accumulation takes place. It can be used to provide horizontal totaling in reports.


Example

acc(1) + order_val * discount


Products

Recital Server, Recital