POWER

In Math & numeric

The POWER function returns the power of the values, using the first input as the base and the second as the exponent. Both inputs can be numbers as well as nodes.

Use this function when you need to raise a node or numeric value to a fixed or row-wise exponent.

Parameters

Base (Node1 | value)Node reference or numberRequired

The value that will be multiplied by itself, specified using the node name in single quotes (e.g. 'Profit')

Exponent (Node2 | value)Node reference or numberRequired

The number of times the base will be multiplied by itself. Can also be a number or a fraction, for example 1/3 to calculate a third root.

Example

Raising one node to the power of another

This example shows POWER applied row-wise using node A as the base and node B as the exponent. Here the exponent is constant at 2, so the result squares each base value.

Input node: 'Base'

Input node: 'Exponent'

Formula: POWER('Base', 'Exponent')

See also

SQRT

When you only need the square root of a single input instead of a general exponentiation.

EXP

When you need exponentiation with the fixed base e instead of a custom base and exponent.