<< Click to display table of contents >>
The following table provides an overview of currency conversions with different <currency> element and <datacolumn><datafield><numeric> amount attribute values.
'amount' attribute |
<currency> element and user selections |
Used in |
Currency conversion |
---|---|---|---|
unit |
No value for the <currency> element |
Input and report templates |
No calculations are done. Data is retrieved from the database in the currency of the selected unit. |
unit |
Third currency (for example, USD) as the value of the <currency> element |
Reports |
Unit amounts are converted to group currency and then to the third currency. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. A currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts are converted to group currency and then to the selected third currency. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. Unit currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts are converted to group currency and then to the unit currency of the selected unit. For reports which have different units (for example, generate reports or reports which have dim00 defined in the definition file), the values of all units are converted to the currency of the unit selected on the Basic Options tab. |
unit |
Variable %USERCURRENCY% as the value of the <currency> element. Group currency selected on the Advanced Options tab. |
Reports with Advanced Options |
Unit amounts is converted to group currency. |
group |
No value for the <currency> element |
Input and report templates |
No calculations are done. Data is retrieved from the database in the group currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. |
group |
Third currency (for example, USD) as the value of the <currency> element |
Input and report templates |
Group amounts are converted to the third currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. A currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
Group amounts are converted to the selected third currency. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. Unit currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
Group amounts are converted to the unit currency of the selected unit. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. Amounts that have been entered in a third currency are first converted to group currency and then to unit currency (both group and unit amounts are saved to the database). |
group |
Variable %USERCURRENCY% as the value of the <currency> element. Group currency selected on the Advanced Options tab. |
Input and report templates with Advanced Options |
No currency conversions are done when retrieving data. Currency conversions apply in input templates when saving data: group amounts are converted to the currency of the selected unit. |