Formatting Numbers

Edit attributes to format integer and real entities for display in table columns, for instance if you need to display them as currency or percentage values. Use the format attribute on <vdl-table-column> elements.

This attribute takes a string representing the format to apply.

Format String Component	Meaning
0	Digit
#	Digit, zero shows as absent
.	Decimal separator
-	Negative sign
,	Grouping separator
%	Percent - multiplies number by 100

In addition to the symbols described above, you can add any arbitrary text, such as a currency symbol.

View Designer

Code editor

<vdl-table page-mode="paged" page-size="5">
	<vdl-table-column entity="Shares_Return" editable="true" format="$#,###.00"></vdl-table-column>
</vdl-table>

© 2001-2023 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation ("FICO"). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.