Param()

Estimated reading time: 1 minute

Function Summary

The Param function transfers values as parameters to the Data Portal. The values must match the order of the parameters in the data source (The order can be verified using the Validation Report ).

For an example of this function, see Lab Drill: Customer Aging.

Function Arguments

Type String/Single Cell
Constraints Max 255 char or must be a single cell
If Blank Will not transfer value

Type String/Single Cell
Constraints Max 255 char or must be a single cell
If Blank Will not transfer value

Excel Formula Bar Example

=ReportRange("NorthwindCustomers",B14:H15,B2:H2,B4:H4,Param(C7,C8,C9),FALSE,FALSE,,FALSE,FALSE)

Function Composition

Argument Name Example Mapping Explanation
Function Name Param() The name of this function.
Value1 C7 The value in C7 will be passed as a parameter to the Data Portal
Val2 C8 The value in C8 will be passed as a parameter to the Data Portal
Val3 C9 The value in C9 will be passed as a parameter to the Data Portal

Usable In These Functions