The pattern( function converts a number into text using a pattern.
Parameters
This function has two parameters:number – is the number you want to convert to text.
pattern – is text that contains a pattern for formatting the number (see Numeric Patterns).
Description
The pattern( function is very useful when used in a formula in an object on a form. Here is a pattern that will output prices with a dollar sign and with a comma every three digits (for example $4,285.25). If the original number has too many digits after the decimal point, the number will be rounded (not truncated) to fit into the formatted text.
pattern(4234.5287,"$#,.##")☞ $4,234.53
For more information on the variety of patterns that are possible, see Numeric Patterns.
See Also
History
| Version | Status | Notes |
| 10.0 | Updated | Carried over from Panorama 6.0, but added engineering notation. |