Smartstaff
119
edits
Changes
→When Using "Show Currency Format in Edit Mode"
<SCRIPT type="text/javascript" language="javascript" src="/sstools.js"></SCRIPT>
==When Using "Show Currency Format Currency Format in Edit Mode"==When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used:
:<span style="font -size="3: medium;">'''ssParseNumByCodessParseNumFromCurrency(value,getLocalestrByCurrency( code),1,emptyok);'''value ''(getLocalestrByCurrency will get the "default" locale of the currency code,e.g. CAD will result in en-CA, NOT fr-CA)'''''<br /><br />OR<br /><br />ssParseNumFromCurrency(value,locale,1,emptyok); '''''(if you know the locale of the formatted currency,e.g. da-DK or fr-FR or fr-CA etc)' ''code<br />'' ');''' </fontspan> Where: <br / >
{| border="1"
|-
!|<b><em>Parameter!|Description|-||'''''value </em></b>'''''||Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000% will be converted to 5000)<br />
|-
|<b><em>|'''''emptyok </em></b>'''''||Optional. Is a true/false value:*if ''emptyok'' is true - an empty string will be returned by ssParseNumByCode if the value is ''empty'':*if ''emptyok'' is false - a "0" will be returned by ssParseNumByCode if the value is ''empty''
|-
|<b><em>|'''''code</em></b>'''''||Required. The three-letter currency code defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]. Example: ''JPY'' for Japanese Yen.
|}
Example:
: <span style="font-size: medium;">ssParseNumFromCurrency([YER Total revenue],getLocalestrByCurrency('CAD'),1,true) - ssParseNumFromCurrency([YER Total expenses],getLocalestrByCurrency('CAD'),1,true)<br /></span>
: <span style="font-size: medium;">or</span>
: <span style="font-size: medium;">ssParseNumFromCurrency([YER Total revenue],'fr-CA',1,true) - ssParseNumFromCurrency([YER Total expenses],'fr-CA',1,true) <br /><br /></span>
==See Also==