Formatting and Styles on result grids
The style of the grid can be set by overriding the global setting of style and business object settings.
Formula formatting example
|
Format string |
Description |
Example |
|
#,### |
Use (,) as 1000 separator |
4700 -> 4,700 |
|
#,###.## |
Use (,) as 1000 separator Decimal precision to 2 digit (Last 0 does not display) |
4700.02 -> 4,700.02 4700 -> 4,700 0 -> |
|
#,##0.00 |
Use (,) as 1000 separator Decimal precision to 2 digit (Last 0 shows on digit position) |
4700 -> 4,700.00 4700.1 -> 4,700.10 0 -> 0 |
|
#,##0;(#,##0) |
Use (,) as 1000 separator Minus values apply different format and bracket () |
4700 -> 4700 -2500 -> (2,500) |
|
$ #,##0 |
Use (,) as 1000 separator $ Symbol is prefix |
4700 -> $ 4,700 |
|
#,##0 % |
Change to percentage (multiply by 100) then add symbol % |
0.2 -> 20 % 20 -> 2,000 % |
|
#,##0 *%* |
Do not multiply value and adding % symbol as postfix |
0.2 -> 0.2 % 20 -> 20 % |
Elapsed time formatting
For the result of the elapsed time measurement formula data, the corresponding time (second) can be converted and output as time-type data such as hour-minute-second.
The output format should use DATE: and the time conversion template used by Java Joda DateFormatter.
For example, if the elapsed time is 260 seconds and the formatting format is applied with DATE: HH: mm: ss, the output is displayed on the grid as 00:04:20.