Difference between revisions of "VALUE"
From AgileApps Support Wiki
imported>Evelyn m |
imported>Aeric |
||
| Line 1: | Line 1: | ||
The VALUE function converts a text string with numbers into a number. | The VALUE function converts a text string with numbers into a number. Since field values are typically returned as strings, this function is used to convert the value to a number. | ||
;Syntax: | ;Syntax: | ||
:<tt>VALUE(string-expression)</tt> | |||
:: The string-expression is usually a field name, but may be more complex | |||
;Return:Number | ;Return:Number | ||
| Line 9: | Line 10: | ||
;Example: | ;Example: | ||
: VALUE(priority) | |||
: Returns 1, 2, 3, etc. depending on the priority-field setting | |||
[[Category:Formula Functions]] | [[Category:Formula Functions]] | ||
Latest revision as of 20:44, 4 March 2014
The VALUE function converts a text string with numbers into a number. Since field values are typically returned as strings, this function is used to convert the value to a number.
- Syntax
- VALUE(string-expression)
- The string-expression is usually a field name, but may be more complex
- Return
- Number
- Example
- VALUE(priority)
- Returns 1, 2, 3, etc. depending on the priority-field setting