add_currency_conversion_calc_group
Creates a currency-conversion calculation group, adding an original value and a converted value that applies daily exchange rates from a rate table.
Instructions
Create a currency-conversion calculation group: an Original Value item and a Converted item that applies the daily exchange rate (SUMX over Date * rate).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | the (single-column) table that becomes the calc group | |
| rateTable | Yes | the exchange-rate table name | |
| sessionId | Yes | ||
| precedence | No | precedence (optional) | |
| rateColumn | Yes | the rate column name | |
| currencyColumn | Yes | the currency column name |