CALCULATE_TOTAL_AND_COMMIT(%add_property%)
This formula can be used to store the total of a set of accounts defined by a common property.
Parameters:
%add_property%
The name of the property defining the accounts to add
To use this formula, add a property to the account dimension:
Enter Y or A (for Add) in all accounts to be added to the total
Enter S in all accounts to be subtracted from the total
Enter T in all accounts where the total is to be stored
Enter a line in the logic that invokes this formula with the appropriate property name, as in the following example:
Example
CALCULATE_TOTAL_AND_COMMIT(ADD1)