Skip to main content

Custom columns with formulas

Create your own columns built as formulas from existing variables, with an optional period.

If you are missing a column, you can create your own — built as a formula from existing variables in AIMZ, much like in a spreadsheet.

How to do it

  1. Open Variables from the table and add a new variable.

  2. Build the formula from existing variables — for example final forecast minus changes from subcontractors.

  3. Optional: set a period on the variable — year to date, last year, change in the current year, or a custom date range.

  4. Save. Custom columns are marked with their own icon in the table.

Setting up a custom column with a formula built from existing variables

This is typical super user functionality — ideally set it up once for the whole organisation, or for a single project with special needs (for example incentive calculations).

Did this answer your question?

Related Articles