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).

Example

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

See also

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?