# Using Aggregations

Monarch Classic includes aggregations which you can use to perform arithmetic functions on the values of a measure in a summary. The following types of aggregations are available in the Edit Measure Expression dialog:

## Cumulative aggregations

Aggregation |
Description |

Cum() |
Returns the cumulative sum. |

CumCount(*) |
Returns the cumulative row count. |

CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |

CumPct() |
Returns the cumulative sum as a percentage of the total sum. |

## Count aggregations

Aggregation |
Description |

Count(*) |
Returns the count of rows (or non-null values of the field) within the group. |

CountPct(*) |
Returns the group row count as a percentage of the total rows. |

CountSubPct(*) |
Returns the group row count as a percentage of the row count in the next larger group. |

CumCount(*) |
Returns the cumulative row count. |

CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |

## Percentage aggregations

Aggregation |
Description |

CountPct(*) |
Returns the group row count as a percentage of the total rows. |

CountSubPct(*) |
Returns the group row count as a percentage of the row count in the next larger group. |

CumCountPct(*) |
Returns the cumulative row count as a percentage of the total rows. |

CumPct() |
Returns the cumulative sum as a percentage of the total sum. |

Pct() |
Returns the group sum as a percentage of the total sum. |

SubPct() |
Returns the group sum as a percentage of the group sum of the next larger group. |

## Statistical aggregations

Aggregation |
Description |

Avg() |
Returns the average value of the field within the group. |

Max() |
Returns the maximum value of the field within the group. |

Min() |
Returns the minimum value of the field within the group. |

Stdev() |
Returns the standard deviation of the field values within the group. |

StdevP() |
Returns the standard deviation (with respect to the population) of the field values within the group. |

Sum() |
Returns the sum of the field values in the group. |

Var() |
Returns the variance of the field values within the group. |

VarP() |
Returns the variance (with respect to the population) of the field values within the group. |

## Special aggregations

Aggregation |
Description |

Unique() |
Returns the unique value of the field if there is a unique value, otherwise returns null. |

© 2024 Altair Engineering Inc. All Rights Reserved.