Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Previous revision
expression function - currency to text [2016/09/12 11:24]
expression function - currency to text [2017/03/22 09:16] (current)
dmclain [Language]
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”,​ etc..  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"​.
Copyright WorkXpress, 2018