Param()
Estimated reading time: 1 minuteFunction 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
Excel
=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 |