Skip to content
Adaptam Docs

WRITE_CALC_V

Creates columns of data fields and calculations presented in a typical table with rows of data.

WRITE_CALC_V function overview

Function syntax

WRITE_CALC_V(field1, calc1, ... | filter1, ... | option1, ...)

Arguments:

  • field1, calc1, …: Data fields or calculations. Calculations include aggregates like SUM(sales), formulas like sales-cost, or combinations like (SUM(sales)-SUM(cost))/COUNT(sales).
  • filter1, …: (optional) One or more data fields containing a filter value(s) that limit the values outputted. Filter values can reference cells, including cells with DROPDOWN selectors.
  • option1, …: (optional) Controls output with options explained in the guides: EVERY [change showing duplicates], LABELS [hide or show column heading labels], LIMIT[number of rows outputted], SORT [change order by field or calculation].

Examples

  • WRITE_CALC_V(product, SUM(sales)) - Product values with total sales.
  • WRITE_CALC_V(region, SUM(sales), SUM(cost)) - Region values with total sales and total costs.
  • WRITE_CALC_V(product, SUM(sales) | country{“USA”}) - Product sales for the country USA.
  • WRITE_CALC_V(product, SUM(sales) || SORT[!calc1{!ZA},product], LIMIT[10]) - Top 10 products sorted by sales. Note, the sort UI populates the sort argument in the formula.