Difference between revisions of "Displaying a Number Value as Currency"
From SmartWiki
Line 11: | Line 11: | ||
|'''Variable Used''' | |'''Variable Used''' | ||
|'''Value will be displayed as...''' | |'''Value will be displayed as...''' | ||
+ | |- | ||
+ | |@format(SampleField,currency,USD)@ | ||
+ | |$300.00 | ||
|- | |- | ||
|@format(SampleField,currency,EUR)@ | |@format(SampleField,currency,EUR)@ |
Revision as of 15:05, 24 June 2013
Fields containing number values can be displayed in currency formats in other custom fields such as Web Page View fields using the following syntax:
@format(FIELD NAME,currency,CURRENCYCODE)@ where FIELD NAME is the name of the field being referenced and CURRENCYCODE is the three-letter currency code used by ISO 4217
Therefore, a field named SampleField containing the value 300 can be displayed as follows:
Variable Used | Value will be displayed as... |
@format(SampleField,currency,USD)@ | $300.00 |
@format(SampleField,currency,EUR)@ | €300.00 |
@format(SampleField,currency,JPY)@ | ¥ 300 |
@format(SampleField,currency,ZAR)@ | R 300.00 |