> ## Documentation Index
> Fetch the complete documentation index at: https://docs.honeycomb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Calculated Field Formula Reference

> Reference for calculated field syntax, operators, and functions, with example formulas to use as inspiration when building your own calculated fields.

Calculated Fields, previously called derived columns, are fields with values calculated by expressions or formulas you provide.

You can learn more about basic syntax, operators, and supported values on the [Calculated Field Syntax](/reference/calculated-field-formula/syntax/) page. If you need some inspiration, check out our [example formulas](/reference/calculated-field-formula/example-formulas/) for some ideas on what you can do with your own calculated fields.

## Available functions

* [Math functions](/reference/calculated-field-formula/math/)
  * [SUM](/reference/calculated-field-formula/math/#sum)
  * [SUB](/reference/calculated-field-formula/math/#sub)
  * [MUL](/reference/calculated-field-formula/math/#mul)
  * [DIV](/reference/calculated-field-formula/math/#div)
  * [MOD](/reference/calculated-field-formula/math/#mod)
  * [MIN](/reference/calculated-field-formula/math/#min)
  * [MAX](/reference/calculated-field-formula/math/#max)
  * [LOG10](/reference/calculated-field-formula/math/#log10)
  * [BUCKET](/reference/calculated-field-formula/math/#bucket)
* [Comparison functions](/reference/calculated-field-formula/comparison/)
  * [LT (less than)](/reference/calculated-field-formula/comparison/#lt)
  * [LTE (less than or equal)](/reference/calculated-field-formula/comparison/#lte)
  * [GT (greater than)](/reference/calculated-field-formula/comparison/#gt)
  * [GTE (greater than or equal)](/reference/calculated-field-formula/comparison/#gte)
  * [EQUALS](/reference/calculated-field-formula/comparison/#equals)
* [Logical functions](/reference/calculated-field-formula/logical/)
  * [AND](/reference/calculated-field-formula/logical/#and)
  * [OR](/reference/calculated-field-formula/logical/#or)
  * [NOT](/reference/calculated-field-formula/logical/#not)
  * [IN](/reference/calculated-field-formula/logical/#in)
  * [EXISTS](/reference/calculated-field-formula/logical/#exists)
* [Conditional functions](/reference/calculated-field-formula/conditional/)
  * [IF](/reference/calculated-field-formula/conditional/#if)
  * [SWITCH](/reference/calculated-field-formula/conditional/#switch)
  * [COALESCE](/reference/calculated-field-formula/conditional/#coalesce)
* [String and Regular Expression functions](/reference/calculated-field-formula/string/)
  * [CONCAT](/reference/calculated-field-formula/string/#concat)
  * [TO\_LOWER](/reference/calculated-field-formula/string/#to_lower)
  * [STARTS\_WITH](/reference/calculated-field-formula/string/#starts_with)
  * [ENDS\_WITH](/reference/calculated-field-formula/string/#ends_with)
  * [CONTAINS](/reference/calculated-field-formula/string/#contains)
  * [REG\_MATCH](/reference/calculated-field-formula/string/#reg_match)
  * [REG\_VALUE](/reference/calculated-field-formula/string/#reg_value)
  * [REG\_COUNT](/reference/calculated-field-formula/string/#reg_count)
  * [LENGTH](/reference/calculated-field-formula/string/#length)
* [Time functions](/reference/calculated-field-formula/time/)
  * [UNIX\_TIMESTAMP](/reference/calculated-field-formula/time/#unix_timestamp)
  * [EVENT\_TIMESTAMP](/reference/calculated-field-formula/time/#event_timestamp)
  * [INGEST\_TIMESTAMP](/reference/calculated-field-formula/time/#ingest_timestamp)
  * [FORMAT\_TIME](/reference/calculated-field-formula/time/#format_time)
* [Type cast functions](/reference/calculated-field-formula/cast/)
  * [INT](/reference/calculated-field-formula/cast/#int)
  * [FLOAT](/reference/calculated-field-formula/cast/#float)
  * [BOOL](/reference/calculated-field-formula/cast/#bool)
  * [STRING](/reference/calculated-field-formula/cast/#string)

<Tip>
  Calculated fields can be created for a specific dataset or for an entire environment.

  * [Create environment calculated fields](/configure/environments/calculated-fields/)
  * [Create dataset calculated fields](/configure/datasets/calculated-fields/)
</Tip>