- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Previous revision Last revision Both sides next revision | ||
expression function - currency to text [2016/09/12 15:24] |
expression function - currency to text [2017/03/22 13:14] dmclain [Currency] |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Currency to Text (Expression Function) ====== | ||
+ | ===== Purpose ===== | ||
+ | The **Currency to Text** function (CURRENCY_TO_TEXT) takes a number, language, and a currency and outputs a text string | ||
+ | |||
+ | {{::currency_to_text_initial.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **Currency to Text** function has three parameters, one of which is required: | ||
+ | |||
+ | ==== Currency Value ==== | ||
+ | |||
+ | Allowed Inputs: [[Field|field]] value or number | ||
+ | |||
+ | The first required parameter is the number that will be converted to text. Either use the use the [[Query Builder]] to choose a field that contains the value or use type a value to enter a number. When using a [[Field Type - Currency|currency]] field choose the number only display part. | ||
+ | |||
+ | ==== Language ==== | ||
+ | |||
+ | Allowed Inputs: Danish (use “dk”), Great British English (use “en_GB”), “en_US”, “es_AR”, “es_MX”, “he”, “hu_HU”, “pl”, “pt_BR”, “ru”, or “tr_TR”. Default is “en_US”. | ||
+ | |||
+ | The second optional parameter of the **Currency to Text** function is the language that the text will be in. | ||
+ | |||
+ | ==== Currency ==== | ||
+ | |||
+ | Allowed Inputs: "USD", “EUR” Default is “USD”. | ||
+ | |||
+ | The third optional parameter of the **Currency to Text** function is the currency label(s) to use. | ||
+ | |||
+ | |||
+ | ===== Output ===== | ||
+ | |||
+ | The output of the **Currency To Text** function is a string representing the currency value. | ||
+ | |||
+ | ===== Example ===== | ||
+ | |||
+ | CURRENCY_TO_TEXT(34.56) would result in "Thirty-Four Dollars and Fifty-Six Cents". |