Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > Working with Data Types and Data Display Formats > Numeric Templates > Numeric Template Examples
Was this helpful?
Numeric Template Examples
The following examples demonstrate the use of numeric templates. This table uses a caret (^) in the output column to represent a space, so that you can better interpret the results:
Format
Example Data
Report Output
(^ indicates a blank space)
'zzzzzzzz'
123
^^^^123
'zZzZz.Zz'
0
^^^^^^^^
'zzzzzzzz.nn'
0
^^^^^^^^.00
'zzzzz.z^'
123.438
^^123.44
'+++,+++,+++'
23456
^^^^+23,456
'‑‑‑,‑‑‑,‑‑‑.NN'
23456.789
^^^^^23,456.79
'‑‑‑,‑‑‑,‑‑‑.zz'
‑3142.666
^^^^^3,142.67
'$$$,$$$,$$$.nnCr'
235122.21
^^^$235,122.21Cr
'$$$,$$$,$$$.nnDb'
‑235122.21
^^^$235,122.21Db
'$zz,zzz,zzn.nn'
1234.56
$^^^^^1,234.56
'$**,***,***.nn'
12345
$****12,345.00
'+$$,$$$,$$$.nn'
54321
^^^+$54,321.00
'nnn\‑nn\‑nnnn'
023243567
023‑24‑3567
'(zzzzz)'
‑123
(^^123)
Last modified date: 11/09/2022