TEXT (Report Builder)
Converts a numeric value to text.
Syntax
TEXT(value)
value |
Indicates the number to convert to a string. |
Remarks
- Converting a numeric value, formula, or field to a text string allows you to concatenate text strings or perform other text functions on the value.
Example
| Formula | Result |
|---|---|
("There are " & TEXT(#Product Inventories)) & " product inventories from which to select." |
Returns the following sentence: There are 1069 product inventories from which to select. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Conversion Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)