SUB Function

The SUB function identifies a row as a subtotal which prevents it from being included in subsequent range calculations.

Command Syntax:

SUB([formula])

EXAMPLE:

This will return the sum of the formula between rows 100 and 1000. 

SUB([100]:[1000])

The values 100 and 1000 in these examples represent Codes in a Line Definition.

Note: In the above example, if a subsequent range calculation uses SUB([50]:[2000]), the SUB function will calculate the sum of the rows between row 50 and row 2000. However, since the row 1100 has a SUB() formula on it, that row will not be included in the total.