Eaze

Eaze is Profitbase InVision's domain-specific formula language for cell calculations in data grids. It targets cells by column address, evaluates expressions, and writes results back — statement by statement.

A typical formula:

@<column>[<row-filter>] = <expression>;

@Amount[] = Price * Qty;

Where Eaze is used

Surface	Role
Worksheet Calculations	Cell formulas on Data Store columns
Worksheet Cell Validation rules	Target + Statement expressions
Worksheet Cell Read-Only rules	Target + Statement expressions
Worksheet Row/Cell Styling	SETROWSTYLE / SETCELLSTYLE conditions
Table calculations (input-table)	Same as Worksheet
SQL Report tabular output	Derived column expressions
Workbook action instructions	Parameters typed boolean \| Eaze expression

Not Eaze: Filter / Caption / Header / Is-Hidden / Visibility fields in the Workbook designer use C# directive expressions (Directive(...), Localize(...), @Object[...], @Context.ObjectAlias) — a different evaluator entirely.

Language reference

• Cell Addressing — @Column[], row predicates, cross-sheet !, @Property[]
• Keywords and Context — true, false, null, this and its properties
• Operators — arithmetic, comparison, logical, null-coalescing
• Execution Model — statement order, recalculation triggers, RecalcAction

Function reference

• Function index — all functions at a glance
• Logical — IF, ISNULL, COALESCE, ISERROR, …
• Math / Trig — SUM, ABS, ROUND, POW, …
• Statistical — AVERAGE, COUNT, MAX, STDEV, …
• Text — CONCAT, SUBSTRING, TOSTRING, …
• Date — DATE, NOW, FORMATDATE, TODATE, …
• Time Frame column helpers — YearNum(), MonthNum(), WeekNum(), …
• Financial — AMORLINC, AMORLINCMTH
• System — EVAL, NEWID, JsonParse, ApiBase, …
• Misc / LHS helpers — LHS(), LHSVALUE(), tmpl_foreach_operand
• Row Collection — ADDROWFIRST, IsSummaryRow, GetCallContextRow, …
• Cell and Row Styling — SETROWSTYLE, SETCELLSTYLE

Workbook context

• App Variables — AppVariables.Factor, getValue(), recalc after change
• Var syntax — @Var[name] notation and assignment rules
• Event context — @Event.Data, @Event.Sender, @Event.Selection
• Filter references — Filter(group, name).SelectedValue

Rules

• Cell Validation — ValidationError / ValidationWarning, Validate()
• Conditional Cell Read-Only — making cells read-only based on data state
• Row Styling — CSS classes on rows and cells from Eaze conditions

Extensibility

• JavaScript Code-Behind — inline JS in Worksheets/Tables (2025.5+)
• Calculation Instance Factory — custom JS calc services via <ComputeInstanceFactory>

Patterns

Idiomatic patterns — derived columns, cross-sheet lookups, dynamic EVAL formulas, AppVariable recalc, and more.