# CalculatedColumnOptions

Canonical page: https://www.adaptabletools.com/docs/reference/calculatedcolumnoptions

Options for managing Calculated Columns in AdapTable

```ts title="TypeScript"
export interface CalculatedColumnOptions 
```

## Properties

| Property | Type | Description | Default |
| --- | --- | --- | --- |
| [aggregatedColumnRowChangeThrottle](https://www.adaptabletools.com/docs/reference/calculatedcolumnoptions.md#aggregatedcolumnrowchangethrottle) | `number` | Coalescing window (in milliseconds) for recomputing Aggregated Calculated<br/>Columns after row data changes (add / update / delete / load).<br/><br/>Bursts of row changes within the window trigger a single recompute of the<br/>aggregated Calculated Columns (the first change recomputes immediately;<br/>subsequent changes within the window are coalesced into one trailing<br/>recompute). Cell-level changes are unaffected — they already refresh only<br/>the Calculated Columns whose referenced columns changed.<br/><br/>Set to `0` to recompute synchronously on every row change (the previous<br/>behaviour). | 300 |
| [formulaTrace](https://www.adaptabletools.com/docs/reference/calculatedcolumnoptions.md#formulatrace) | [`FormulaTraceOptions`](https://www.adaptabletools.com/docs/reference/formulatraceoptions.md) | Options for the Excel-style Formula Trace (highlighting cells that feed a calculated value) |   |

## Property Details

### aggregatedColumnRowChangeThrottle

Coalescing window (in milliseconds) for recomputing Aggregated Calculated
Columns after row data changes (add / update / delete / load).

Bursts of row changes within the window trigger a single recompute of the
aggregated Calculated Columns (the first change recomputes immediately;
subsequent changes within the window are coalesced into one trailing
recompute). Cell-level changes are unaffected — they already refresh only
the Calculated Columns whose referenced columns changed.

Set to `0` to recompute synchronously on every row change (the previous
behaviour).

```ts title="TypeScript"
aggregatedColumnRowChangeThrottle?: number;
```

###### Default Value

300

###### Property Value

`number`

### formulaTrace

Options for the Excel-style Formula Trace (highlighting cells that feed a calculated value)

```ts title="TypeScript"
formulaTrace?: FormulaTraceOptions;
```

###### Property Value

[`FormulaTraceOptions`](https://www.adaptabletools.com/docs/reference/formulatraceoptions.md)