Trace:

Differences

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

--- 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".

expression function - currency to text.txt · Last modified: 2017/03/22 13:16 by dmclain

Show page Old revisions

Recent Changes Sitemap Back to top