The numerical values to raise to an exponential power. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of base (same as data), see the "Macro Function Parameters" section in the chapter in this guide for your IBM® Unica® product.

The exponential number(s) to raise the values in data by. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. The number of columns in exponent must equal the number of columns in base, unless base is a constant. For the format definition of exponent (same as data), see the "Macro Function Parameters" section in the chapter in this guide for your IBM® Unica® product.

POW raises the values in the first data range to the power specified in the second data range (that is, calculates ). It returns one new column for each input column, each containing the result of raising the base to the exponent power (that is, the first column of data1 is raised to the first column of data, the second column with the second column, and so on).

If exponent is a constant, each value in base is raised by that value. If exponent contains one or more columns, the calculations are performed on a row-by-row basis between one column from base and one column from exponent. The first row of base is raised to the first row value of exponent, the second row with the second row, and so on. This row-by-row calculation produces a result for each row up to the last value of the shortest column.