Advanced Topics - Parameterized Variables book example question

[jblomqvist]

Hi,

In the Advanced Topics book on page 84 for Advanced Set Analysis, it uses the example of

Sum($1) / Sum(TOTAL $1)

What does the 1 represent? Is it a variable? It is not clear what is meant by this in the book.

Thanks

[Gysbert_Wassenaar]

$1 means the first parameter passed to the variable. In this case it's also the only parameter and it would be a field name. For example

eSales: Sum($1) / Sum(TOTAL $1)

Expression: =if( vCurrency = 'USD', $(eSales(Sales_USD)), $(eSales(Sales_EUR)))