Worksheet parameter overrides
These parameters can be used to override the values for the worksheet parameter:
- %empty%: Overrides the default value with a Null value.
- %default%: Appends values to the default values. The user must verify the format used for the appended values.
Note: The %default% parameter cannot used to override the rv_measure_format and rv_measure_calc
values due to the complexity of these parameters.
This table describes the examples of overriding the default value using parameter variables:
| Default value | Override value | Resultant value |
|---|---|---|
| {[measure1],[measure2]} | %default%,{[measure3]} | {[measure1],[measure2]},{[measure3]} |
| {[measure1],[measure2]} | {[measure3]},%default%,{[measure4]} | {[measure3]},{[measure1],[measure2]},{[measure4]} |
| {[measure1],[measure2]} | %empty% | |
| I | %default%,L | I, L |