SUM Function

The SUM function takes a variable number of parameters and provides a sum total of the values. The parameters in a SUM function can be individual parameters, a range or a combination of the two.

 

Note: The SUM function behaves in the same manner as entering the specific single line or column Codes (i.e. [5100]+[5200]+[5300] OR [5100]:[5300]+[5400] OR [B]+[C]+[D])

 

Command Syntax:

SUM([parameter1],[parameter2],[parameter3]…)

SUM([parameter1]:[parameter2])

 

EXAMPLE:

This formula sets a column to sum a value of a set of parameters. In this instance, the columns sum to a YTD total for accounts.

SUM([B]:[L])

 

Column Definition

 

Report Output