Aggregates the Accounts member based on its Time Balance behavior.
Syntax
Aggregate ( set [, accounts_member] )
Parameter | Description |
---|---|
set | A set containing tuples to be aggregated. If empty, #Missing is returned. |
accounts_member | A member from an Accounts dimension. If omitted, the current member from Accounts is used. |
Notes
For each tuple in set, the value of accounts_member is evaluated.
If accounts_member has no time balance tag, or if set is one-dimensional, this function behaves the same as Sum().
If accounts_member has a time balance tag, this function behaves as follows:
For TB First, returns the value of accounts_member for the first tuple in set.
For TB First with SKIP, scans tuples in set from first to last and returns first tuple with non-empty value for accounts_member.
For TB Last, returns the value of accounts_member for the last tuple in set.
For TB Last with SKIP, scans tuples in set from last to first and returns first tuple with non-empty value for accounts_member.
For TB Average, returns the average of values of accounts_member at each tuple in set.
For TB Average with SKIP, returns the average of value of accounts_member at each tuple in set without factoring empty values.