Is an aggregate period

A relative reference in @if statements. Used with memo accounts, ratio accounts, and covenant accounts in time period structures that yield aggregate periods.

For example, if a model is in quarterly detail a year end aggregate period is created. The same applies to months, half years, and subperiods. Used in @if statements, different calculations can be performed in these aggregate periods.


  • True—if the period is an aggregate period

  • False—if not


If a model is in quarters and the year end is an aggregate period, this formula:


returns 2 in each of the four quarters and 1 in the year end aggregate.


This function only works when one of the User Defined Accounts is a calculated (CALC) field and the None option is selected.

See Using User-Defined Accounts.