Computed columns in AGR (Insights)
Computed Columns let you create custom numeric columns in a report by writing formulas based on existing fields (for example: stockUnits + undelivered).
Computed Columns are available for Insights Pro only.
How Computed Columns work
A computed column consists of:
A custom column name (chosen by you)
A formula (based on other numeric columns)
A format (how the values are displayed)
Once saved, the computed column becomes available in that report, just like any other numeric column.
✅ You can create more than one computed column per report.
Report-level scope (how they are saved)
Computed Columns are scoped to a single report, meaning:
The column is saved in the report where it was created
If you open another report, the computed column won’t be there automatically
To reuse it, you can recreate it or use Save report as… to carry it over
This works similarly to Advanced Filters, where the setup is stored inside the report instead of being managed globally.
Writing formulas
Computed Columns currently support numeric formulas only.
Supported operators
You can use the following operators:
+ (add)
- (subtract)
* (multiply)
/ (divide)
You can use brackets to control the order of operations:
(stockUnits + undelivered) / 2
Using columns in your formula
To insert a column into your formula, type
@
This opens a list of available columns you can use.
You can also search by name, for example:
@leadtime
Then select the column to insert it into your formula.
Comments
You can add comments to your formula to make it easier to understand later.
Use // for comments:
1 + 1 // this creates a column with the value 2
Comments don’t affect the result - they are only for readability.
Formatting the computed column
You can choose how the computed column is displayed. Available formats include:
Integer
Decimal
Currency
Percentage
Formatting only affects how values are shown in the report - it doesn’t change the underlying calculation.
Data type rules
Computed Columns only support numeric values.
That means:
✅ Numeric fields work (for example stockUnits, costPrice)
❌ Text values are not supported
❌ If you enter a word (text), AGR will show an error