Currency Data Type |
Currency refers to numerical inputs of monetary amounts. You can specify a currency for differing locales and configure various formatting options.
On the Data Type tab, the following options are available for Currency data sources:
Locale. Specifies the language and country of the desired currency format.
Use native numerals. Specifies whether to use Arabic numerals or the native numeric system when using a Locale that supports alternative numeric systems. Available for the following locales: Arabic (Bahrain, Egypt, Iraq, Jordan, Kuwait, Lebanon, Oman, Qatar, Saudi Arabia, Syria, U.A.E., Yemen), Assamese (India), Bengali (Bangladesh, India), Dari (Afghanistan), Gujarati (India), Kannada (India), Khmer (Cambodia), Konkani (India), Lao (Lao P.D.R.), Malayalam (India), Marathi (India), Nepali (Nepal), Oriya (India), Pashto (Afghanistan), Persian (Iran), Punjabi (India), Sanskrit (India), Telugu (India), Thai (Thailand), and Urdu (Islamic Republic of Pakistan).
Use digit grouping separator. When enabled, separates the number into groups using a delimiter; this digit is also known as the thousands separator because it separates the number at every third digit, the thousands spot.
Show leading zero. When enabled, displays a zero before a decimal number.
Decimal places. Specifies the number of decimal places to include in the number.
Positive currency. Defines the formatting of any positive currency values contained in the data source.
Negative currency. Defines the formatting of any negative currency values contained in the data source.
Text • Date • Time • Number • Percentage • Fraction • Binary • Picture • Data Type Tab