Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
$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)))