Framework:Formatstrings: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The following format strings can be used in [[Framework:BI_Center:Create_Input_Mask|input mask]], [[Framework:BI_Center: | The following format strings can be used in [[Framework:BI_Center:Create_Input_Mask|input mask]], [[Framework:BI_Center:Create_Analysis_View|analysis view]] or [[Framework:BI_Center:Create_Row_View|row view]]. | ||
Revision as of 11:03, 24 November 2010
The following format strings can be used in input mask, analysis view or row view.
| Caption | Description | Example |
| N0 | The numeric ("N0") format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol. | 1,235 |
| N2 | The numeric ("N0") format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol and using two fractional digits. | 1,234.56 |
| P0 | The percent ("P") format specifier multiplies a number by 100 and converts it to a string that represents a percentage. | 123456% |
| P2 | The percent ("P") format specifier multiplies a number by 100 and converts it to a string that represents a percentage and using two fractional digits. | 123456.00% |
| # | The # format specifier converts a number to a string. | 1234 |
| #.00 | The # format specifier converts a number to a string and using two fractional digits. | 1234.56 |
| #,###.00 | The # format specifier converts a number to a string, using two fractional digits and the "," indicates a group separator. | 1,234.56 |