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 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.
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.
=Pow(Fields!Orders.Value, 4)
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.
