/
Supportvalsight.ai
Open in ClaudeOpen in ChatGPT

SQRT

SQRT('Node')

In Math & numeric

The SQRT function returns the square root of each value in the input.

Use this function when you need the square root of positive values for scaling, normalization, or mathematical transformations.

Parameters

NodeNode referenceRequired
Input node, specified using the node name in single quotes (e.g. 'Profit').

Watch out

  • Use POWER for other roots (e.g. cube roots via a fractional exponent).
  • A negative input value makes the whole calculation fail, not just that one row. SQRT is a POWER with the exponent 0.5, and a negative base with a fractional exponent is undefined. Wrap the input in MAX('Node', 0) or ABS if negatives are possible.

Examples

Square root of positive input values

This example shows the square root computed for a node with simple positive values. Each result is the square root of the corresponding input value.

Input node: 'A'

YearValue
20254
20269
202725

Formula: SQRT('A')

YearSQRT Result
20252
20263
20275
POWER
When you need other roots or a general exponentiation instead of only the square root of a single input.
LN
When you need a logarithmic transformation instead of taking the square root of the input.
Was this page helpful?