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

From SmartWiki
Jump to: navigation, search
Line 21: Line 21:
 
|R 300.00
 
|R 300.00
 
|}
 
|}
 +
 +
==See Also==
 +
* [[Number Format]]
  
 
[[Category:Variables]][[Category:Currency]]
 
[[Category:Variables]][[Category:Currency]]

Revision as of 16: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