Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
FRACTODEC – Convert fraction to decimal
Overview
This Custom Field converts a string containing a fraction into a decimal value. The command requires two parameters: the string containing the fraction to convert and the number of decimal places to be which the converted figure will be displayed.
Syntax
FRACTODEC(String,Precision)
| Element | Description |
|---|---|
| String | A string in a field displayed as a fraction. |
| Precision | The number of decimal places in the converted number. |
Examples
FRACTODEC(FIELDSTR(size),2) will return a list of values from a ‘size’ field, displayed to two decimal places.
FRACTODEC(‘1/2’,2) will return 0.50.
FRACTODEC(‘3/8’,3) will return 0.375.
FRACTODEC(‘3/8’,2) will return 0.38.
FRACTODEC(‘3/8’,1) will return 0.4.
See also