Define the Query.

[eromiyasimon]

Can someone explain the below query

( SUM({<FLAG_QUESTION = {$1}>}FLAG_PROMOTER) / SUM({<FLAG_QUESTION = {$1}>}FLAG_GROUP_ALL) * 100 )

-

( SUM({<FLAG_QUESTION = {$1}>}FLAG__DETRACTOR) / SUM({<FLAG_QUESTION = {$1}>}FLAG_GROUP_ALL) * 100)

[marcus_sommer]

$1 refers to the first parameter of a parametrized variable which is usually called like:

$(var(1))

See also:

Variable That Acts Like a User-Defined Function.

Dynamic Field Expressions with Variables

Variables with Parameters

- Marcus