Difference between revisions of "ACC()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return report accumulator | Function to return report accumulator | ||
| Line 26: | Line 22: | ||
==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:35, 25 November 2009
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
