Skip to content
Adaptam Docs

MIN_AVERAGE

Calculates the smallest AVERAGE data field value for single or multi-loop data field value groups, all subject to data field filters if desired. Where the output can be changed to the second, third or so on highest AVERAGE. Where the output can also be changed to the corresponding loop field group value.

MIN_AVERAGE function overview

Function syntax

MIN_AVERAGE(AVERAGE input | Loop1, ... | filter1, ... | OUTPUT[field], RANK[n])

Arguments:

  • AVERAGE input: The data field to average.
  • Loop1, …: The data field to split the data (e.g., by product, by region) for the averages. Multiple loop fields supported.
  • filter1, …: (optional) The data field and value(s) used to limit the data. Can reference a cell (including DROPDOWN cells) for the field filter value.
  • OUTPUT[field]: (optional) Select the loop field corresponding value as the output instead of the average.
  • RANK[n]: (optional) Return the Nth lowest average instead of the minimum (e.g., RANK[2] for second lowest).

Examples

  • MIN_AVERAGE(sales | product) - Lowest average of sales by product.
  • MIN_AVERAGE(sales | product | channel{“Online”}) - Lowest average sales by product, Online channel only.
  • MIN_AVERAGE(sales | product | | OUTPUT[product]) - Which product has the lowest average sales.
  • MIN_AVERAGE(sales | product | | OUTPUT[product], RANK[2]) - Which product has the second lowest average of sales.
  • MIN_AVERAGE(sales | product, region) - Lowest average of sales by product and region combined.