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

From SmartWiki
Jump to: navigation, search
Line 6: Line 6:
 
  and ''CURRENCYCODE'' is the three-letter currency code used by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]
 
  and ''CURRENCYCODE'' is the three-letter currency code used by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]
  
−
Therefore, a field containing the value ''300'' can be displayed as follows:
+
Therefore, a field named ''SampleField'' containing the value ''300'' can be displayed as follows:
  
 
{| border="1"
 
{| border="1"
Line 12: Line 12:
 
|'''Value will be displayed as...'''
 
|'''Value will be displayed as...'''
 
|-
 
|-
−
|Organization, Search People
+
|@format(SampleField,currency,EUR)@
−
|People: internal and external, related companies, standard and custom fields.
+
|€300.00
 
|-
 
|-
−
|Communications, Contacts
+
|@format(SampleField,currency,JPY)@
−
|External people only - limited search capabilities.
+
|¥300
 
|-
 
|-
−
|[[Universal Tracking Application]] > Contact Tab
+
|@format(SampleField,currency,ZAR)@
−
|Same page as the ''Search People'' page.
+
|R 300.00
−
|-
 
−
|[[Universal Tracking Application]] > Company Tab
 
−
|Same functionality as the ''Search People'' page, but with companies.
 
−
|-
 
−
|Sales Tracking Application > Company Tab
 
−
|Same page as the Company tab in the [[UTA]]
 
−
|-
 
−
|Sales Tracking Application > Contacts Tab
 
−
|Same page as the ''Search People'' page
 
−
|-
 
−
|Sales Tracking Application > My Contacts
 
−
|Limited to contacts associated with companies where the current user is the owner.
 
 
|}
 
|}
  
 
[[Category:Variables]][[Category:Currency]]
 
[[Category:Variables]][[Category:Currency]]

Revision as of 16:02, 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
Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Displaying_a_Number_Value_as_Currency&oldid=15803’