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

From SmartWiki
Jump to: navigation, search
Line 16: Line 16:
 
|-
 
|-
 
|@format(SampleField,currency,JPY)@
 
|@format(SampleField,currency,JPY)@
|¥300
+
|¥ 300
 
|-
 
|-
 
|@format(SampleField,currency,ZAR)@
 
|@format(SampleField,currency,ZAR)@

Revision as of 15:03, 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,EUR)@ €300.00
@format(SampleField,currency,JPY)@ ¥ 300
@format(SampleField,currency,ZAR)@ R 300.00

See Also