Building and Using Dashboards > Dashboard Function Reference > Scalar Functions > Format Number
Format Number
Returns a string representing the specified number in the specified format.
For example, if Number To Format is 50, and Format is $, the function returns $50.00.
Arguments
This function has the following arguments:
*Number To Format: Numeric value specifying the number to be formatted.
*Format: Text string specifying the format of the function result. The format can be specified based on the Java format specification, or with the following shorthand: $ for US dollar money values, $$ for US dollar money values with additional formatting, or () for non-money values, formatted similar to money. Both positive and negative formats can be supplied, for example: #,###;(#,###).
The function returns a text string
Copyright © 2013-2015 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.