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
Value1
Type String/Single Cell
Constraints Max 255 char or must be a single cell
If Blank Will not transfer value
Val2 - Val40
Type String/Single Cell
Constraints Max 255 char or must be a single cell
If Blank Will not transfer value
=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