Difference between revisions of "SsParseNum"
From SmartWiki
(→When Using "Show Currency Format in Edit Mode") |
|||
| Line 41: | Line 41: | ||
==When Using "Show Currency Format in Edit Mode"== | ==When Using "Show Currency Format in Edit Mode"== | ||
| − | When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used: | + | When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used: |
| − | :<font size | + | : <span style="font-size: medium;">'''ssParseNumFromCurrency(value,getLocalestrByCurrency(code),1,emptyok);'''</span> |
| − | + | Where: | |
| − | Where: | ||
{| border="1" | {| border="1" | ||
| − | |||
| − | |||
|- | |- | ||
| − | | | + | !|Parameter |
| − | | | + | !|Description |
|- | |- | ||
| − | | | + | ||'''''value ''''' |
| − | |Optional. Is a true/false value | + | ||Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000 will be converted to 5000) |
| − | :*if ''emptyok'' is true - an empty string will be returned by | + | |- |
| − | :*if ''emptyok'' is false - a "0" will be returned by | + | ||'''''emptyok ''''' |
| + | ||Optional. Is a true/false value | ||
| + | :* if ''emptyok'' is true - an empty string will be returned by if the value is ''empty'' | ||
| + | :* if ''emptyok'' is false - a "0" will be returned by if the value is ''empty'' | ||
| + | |||
|- | |- | ||
| − | | | + | ||'''''code''''' |
| − | |Required. The three-letter currency code defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]. Example: ''JPY'' for Japanese Yen. | + | ||Required. The three-letter currency code defined by [http://en.wikipedia.org/wiki/ISO_4217 ISO 4217]. Example: ''JPY'' for Japanese Yen. |
|} | |} | ||
Example: | Example: | ||
| − | :<font size | + | : <span style="font-size: medium;">ssParseNumFromCurrency([YER Total revenue],getLocalestrByCurrency("CAD"),1,true) - ssParseNumFromCurrency([YER Total expenses],getLocalestrByCurrency("CAD"),1,true)</span> |
==See Also== | ==See Also== | ||
Revision as of 10:35, 17 December 2020
| This feature uses JavaScript syntax |  |
Contents
Overview
To convert a number from a formatted string (containing symbols like "$" or "%") to a number using JavaScript you can use a function called ssParseNum.
Syntax
- ssParseNum( value, emptyok );
Where:
| Parameter | Description |
|---|---|
| value | Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000% will be converted to 5000) |
| emptyok | Optional. Is a true/false value
|
Examples
ssParseNum($5,000.50);
Will return: 5000.5
If you wish to display a ratio of two fields that are set to have currency formatting, you should convert the values to numbers using ssParseNum:
ssParseNum([field1])/ssParseNum([field2])
Requirements
This function is part of the sstools.js library and needs to be added to Browser Script custom fields or on template pages, sign-up pages etc. using the following syntax:
<SCRIPT type="text/javascript" language="javascript" src="/sstools.js"></SCRIPT>
When Using "Show Currency Format in Edit Mode"
When using the "Show Currency Format in Edit Mode" setting for custom fields, the following syntax must be used:
- ssParseNumFromCurrency(value,getLocalestrByCurrency(code),1,emptyok);
Where:
| Parameter | Description |
|---|---|
| value | Required. Is the value to be converted to a number (i.e: $5,000.00 and 5,000 will be converted to 5000) |
| emptyok | Optional. Is a true/false value
|
| code | Required. The three-letter currency code defined by ISO 4217. Example: JPY for Japanese Yen. |
Example:
- ssParseNumFromCurrency([YER Total revenue],getLocalestrByCurrency("CAD"),1,true) - ssParseNumFromCurrency([YER Total expenses],getLocalestrByCurrency("CAD"),1,true)
