4.8.4 Defining Custom Number Format Multipliers
When applying a number format, users can add a suffix “K”, “M”, or “B” to the pattern string to automatically divide the numerical value by 103, 106, and 109, respectively.

You can define custom symbols and multipliers by adding the desired entries to the userformat.xml file in the server repository (WEB-INF/classes by default). For example, the following userformat.xml file defines three new multipliers, “halfK”, “halfM”, and “halfB”, that divide the numerical values by 5x102, 5x105, and 5x108, respectively.
<?xml version="1.0" encoding="utf-8"?>
<userFormat>
<NumberFormat suffix="halfK" multiplier="500"/>
<NumberFormat suffix="halfM" multiplier="500000"/>
<NumberFormat suffix="halfB" multiplier="500000000"/>
</userFormat>
When you restart the server with this userformat.xml file in place, the new suffixes will be available for use with number format patterns, and will be displayed among the format presets for reports and Viewsheets:

The default suffixes can be redefined but not removed.
To redefine the existing “K”, “M”, or “B” suffixes, simply assign these suffixes new values in the userformat.xml file.
<NumberFormat suffix="K" multiplier="..."/>
<NumberFormat suffix="M" multiplier="..."/>
<NumberFormat suffix="B" multiplier="..."/>
See Also
Number Format, in Dashboard Design, for information about formatting a Viewsheet.
Number Formats, in Report Design, for information about formatting a report.
| << 4.8.3 Localizing Reports, Viewsheets, Data Models/Queries | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.9 Tailoring Server Performance >> |