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