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
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
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 |