Skip to main content

Aggregate Functions

Aggregate functions allow operations over aggregated values.

Simple_Agg(start_member, expression)​

Performs simple aggregation of expression over the range start_member:CurrentMember. expression can be tuple or a member expression. start_member must be a single dimensional member expression that evaluates to a single member. Derivations are supported (i.e. [Account].[Rent].NextMember), but relative references ([Account].CurrentMember.PrevMember) are not supported in either start_member nor expression.

Simple_Agg() is designed mainly for flow calculations. Example:

scope ([Scenario].[Actual], [Account].[Retained Earnings], range([Period].&[202501], [Period].[&202512]))
    [New] = [Account].[Net Income]
    [Closing] = ([Period].&[202412], [@Measure].[Closing]) + Simple_Agg([Period].&[202501], [@Measure].[New])
end scope

See Also​