> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Operators overview

Sigma supports basic operators for calculations, evaluating them in accepted order. You can use these operators when developing the conditions of [Logical functions](/docs/logical-functions).

Sigma supports many operators.

## Example

When calculating values, such as using the addition operator **+** to add two values, the result is Null if one of the values is Null.

`[Column 1] + [Column 2]`

If the value of `[Column 2]`  is Null, then the result of the entire formula is Null.

To resolve this, you can apply the [Zn](/docs/zn) function to each value, to substitute 0 for Null:

`Zn([Column 1]) + Zn([Column 2])`

<dl>
  <dt id="dot">
    .
  </dt>

  <dd>
    Class division notation. Used to navigate through the levels of Variant and JSON data types
  </dd>

  <dt id="plus">
    \+
  </dt>

  <dd>
    Adds two numbers
  </dd>

  <dt id="minus">
    \-
  </dt>

  <dd>
    Subtracts one number from another
  </dd>

  <dt id="multiply">
    \*
  </dt>

  <dd>
    Multiplies two numbers
  </dd>

  <dt id="divide">
    /
  </dt>

  <dd>
    Divides one number by another
  </dd>

  <dt id="power">
    ^
  </dt>

  <dd>
    Raises a number to the specified power
  </dd>

  <dt id="modulo">
    %
  </dt>

  <dd>
    Modulo computes the remainder of dividing X by Y
  </dd>

  <dt id="ampersand">
    &
  </dt>

  <dd>
    Ampersand concatenates two strings together
  </dd>

  <dt id="less-than">
    \<
  </dt>

  <dd>
    Determines if X is less than Y
  </dd>

  <dt id="less-than-or-equal">
    \<=
  </dt>

  <dd>
    Returns whether X is less than or equal to Y
  </dd>

  <dt id="greater-than">
    \>
  </dt>

  <dd>
    Returns whether X is greater than y
  </dd>

  <dt id="greater-than-or-equal">
    \>=
  </dt>

  <dd>
    Returns whether X is greater than or equal to y
  </dd>

  <dt id="equal">
    \=
  </dt>

  <dd>
    Returns whether x is equal to y
  </dd>

  <dt id="not-equal">
    !=
  </dt>

  <dd>
    Returns whether x is not equal to y
  </dd>

  <dt id="parenthesis">
    ()
  </dt>

  <dd>
    Used to change the order of operations
  </dd>

  <dt id="and">
    AND
  </dt>

  <dd>
    Returns whether two logical values are both TRUE
  </dd>

  <dt id="or">
    OR
  </dt>

  <dd>
    Returns whether either of two logical values are TRUE
  </dd>

  <dt id="not">
    NOT
  </dt>

  <dd>
    Negate a value or expression
  </dd>

  <dt id="true">
    TRUE
  </dt>

  <dd>
    Interpreted as the Boolean literal TRUE
  </dd>

  <dt id="false">
    FALSE
  </dt>

  <dd>
    Interpreted as the Boolean literal FALSE
  </dd>

  <dt id="null">
    NULL
  </dt>

  <dd>
    Interpreted as a null literal
  </dd>
</dl>