Difference between revisions of "Displaying a Number Value as Currency"
From SmartWiki
| Line 24: | Line 24: | ||
|R 300.00 | |R 300.00 | ||
|} | |} | ||
| + | |||
| + | * Currency formatting will be applied when the record is in [[edit mode]] only if the setting "Show Currency Format in Edit Mode" is selected in the custom field settings. | ||
==See Also== | ==See Also== | ||
Revision as of 09:25, 4 November 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 |
- Currency formatting will be applied when the record is in edit mode only if the setting "Show Currency Format in Edit Mode" is selected in the custom field settings.
