SUM Function
The SUM function adds all of the numbers in the specified parameters. If the SUM function references a multi-selection values list, it can be used with the SELECTED function to return the sum of the numeric values for each of the currently selected items.
Return Type: Numeric
Syntax: SUM(number1, number2,...)
In the above syntax, parameters in bold are required.
Parameter |
Description |
---|---|
number1, number2, |
Parameters for which you want the total value. These parameters can be entered as hard-coded values, for example, 2, or Numeric-field references, for example, [field name]. Referenced fields can reside within the application or within Sub-Form, Cross-Reference, or Related Records fields. |
Examples:
Formula |
Result |
---|---|
SUM(3, [Risk]) where the value in the Risk field is 12. |
15 |
SUM([Risk], [Criticality]) where the value in the Risk field is 12 and the value in the Criticality field is 7. |
19 |
SUM(REF([Orders],[Price])) where the value in the Price field within the Orders sub-form are 120.00, 50.19, and 32.75. |
202.94 |
SUM(SELECTEDVALUENUMBER([Key Factors])) where Key Factors is a multi-selection Values List field and the numeric values of the current selections are 3, 8, 4, and 10. |
25 |