SSRS Pow Function

The SSRS Pow function is a Mathematical function that returns the given number (numeric field) raised to the given power. The syntax of the Pow function to return the number raised to the power is as shown below. This function accepts two arguments: the first argument is the base value, and the second argument is the exponent. For instance, Pow(3, 2) = 9.

=Pow(Fields!Income.Value, 2)

To demonstrate the SSRS Pow function, we use the Products table below, which has 14 records. The image shows the records in the table report; the result is in an empty column.

Source Table

SSRS Pow function Example

To do this, right-click the textbox under the Result Header and choose the Expression to open the window below. The Pow function below uses the 4 (second argument) to find the orders (column) raised to the power of four.

  1. More Functions
  2. Charts
  3. Tables
  4. Format tables
  5. SSRS
=Pow(Fields!Orders.Value, 4)
SSRS Pow Function to find the power of a number

Similarly, let me create one more new column to the right of the Cost and name it Cost Orders. The SSRS Pow function below the expression finds the Standard Cost column’s power raised to the Orders field’s power.

=Pow(Fields!StandardCost.Value, Fields!Orders.Value)

Please click the preview tab to see the Pow report. Please use the FormatNumber function to adjust the decimal precisions.

SSRS Pow Function to find the power of a number report preview