GETPROMPTVALUE

GETPROMPTVALUE syntax uses a column filter, also known as a prompt in Original Dashboards, or a parameter filter.

Syntax:

GETPROMPTVALUE('filter_column_name|parameter_name', 'optional_default_value')

• When prompt filter values are used in report expressions, they are by default returned as strings and must be cast to numeric data types if they are used in arithmetic functions.
• The optional second argument, the default value, must be a VARCHAR data type or NULL.
• The optional second argument, the default value, can also be supplied by a variable using GETVARIABLE. GETPROMPTVALUE('Products.Products', VARCHAR(GetVariable('Default Product')))

We recommend that the optional second argument is defined to use if the first argument is not a currently defined prompt.