Difference between revisions of "Displaying a Number Value as Currency"

From SmartWiki
Jump to: navigation, search
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 16: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

See Also