Eaze Calculations
Tables support cell calculations written in Eaze — Profitbase InVision's formula language for data grids. The syntax and function set are identical to Worksheets.
A calculation formula has this shape:
@<column>[<row-filter>] = <expression>;
@Amount[] = Price * Qty;
@Amount[ProductID == "XP-5000"] = @Price[ProductID == "XP-5000"] * @Qty[ProductID == "XP-5000"];
Multiple statements run in order. Each formula targets one or more cells by column name and an optional row predicate.
Full Eaze reference
All language details, operators, functions, and Workbook context are documented in the shared Eaze reference:
- Eaze overview — where Eaze is used and how to navigate the docs
- Cell Addressing — column references, row predicates, cross-sheet
! - Operators
- Keywords and Context —
this,this.Rows,this.DataSets - Execution Model — statement order,
RecalcAction - Function Reference — all built-in functions
- App Variables —
AppVariables.Factor,getValue() - Patterns — idiomatic examples
Extensibility
- JavaScript Code-Behind — inline JS in Tables (2025.5+)
- Calculation Instance Factory — custom JS calc services