Return the total value of related objects
You can use the USER_SYM_ACT subroutine with the TOTAL.VALUES argument in a complex User Symbolic to return the total value of all related objects in an Activity record.
Subroutine name
USER_SYM_ACT
Subroutine argument
TOTAL.VALUES
Example of use
You could add up the acquisition price for all of the objects.
Argument syntax and parameters
The subroutine is a piece of code that uses ‘arguments’. An argument is a set of options that tells the subroutine what to do. The argument parameters are commonly separated by an exclamation mark.
The TOTAL.VALUES subroutine argument structure is:
TOTAL.VALUES!arg2
What the argument parameters mean
Argument parameter | Required or optional? | Explanation | Example |
---|---|---|---|
arg2 | Required | The Field Mark Count (FMC) of the Object field to extract the value from. If the field specified is multi-valued, then the first value in the table is used. | 129 |
Example of subroutine argument
This argument will show the total of all the Acquisition Price fields (FMC 129) for related Object records.
TOTAL.VALUES!129