Show TOC

Syntax documentationCALCULATE_TOTAL_AND_COMMIT Locate this document in the navigation structure

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 Example

CALCULATE_TOTAL_AND_COMMIT(ADD1)

End of the example.