Using a property in a calculated expression
In this example, assume you are trading with foreign countries, and the figures you want to visualize are dependent on the current exchange rates. Then, you can create a property that can assume different exchange rates and include this property in the conversion calculations. Anyone using the analysis can then simply adjust the value of the property to reflect the current exchange rate, and automatic recalculations will take place immediately. Both the property creation and the property value modifications can be handled from a text area.
Before you begin
Procedure
Results
${ExchangeRate}*[Amount]
in the
Expression field (note the syntax).
Now you can drag the slider to the current exchange rate, and the
amounts in the added column are automatically converted using the specified
exchange rate.

