| Syntax: |
TOTAL N value |
| Return Value: |
N value |
| Description: |
This operator allows you to reference the running total of a field that is being totalled. The value returned is the total including the current line. On a subtotal line, the formulas defining fields are re-evaluated using the appropriate total value of any totalled field requested, so the use of the TOTAL operator is unnecessary in that case |
| Example: |
When referring to the current total on a detail line, for example in calculating a moving average, you could use: TOTAL ORDER_VALUE/TOTAL COUNT where ORDER_VALUE is a totalled database field, and COUNT is a totalled, calculated field with the formula: 1 |