Framework:Formatstrings: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
Created page with "The following format strings can be used in input mask, analyse view or [[Framework:BI_Cente..." |
No edit summary |
||
| (13 intermediate revisions by the same user not shown) | |||
| 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]]. | ||
{| | {| class="wikitable" | ||
|- {{Tabellentitel}} | |||
| width="200pt" |Caption | |||
| width="500pt" |Description | |||
| width="200pt" |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. | |||
| | |align="right"|1,235 | ||
|- | |- | ||
| | |n2 | ||
| | |The numeric ("n2") 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. | |align="right"|1,234.56 | ||
|- | |- | ||
| | |p0 | ||
| | |The percent ("p") format specifier multiplies a number by 100 and converts it to a string that represents a percentage. | ||
| | |align="right"|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. | ||
| | |align="right"|123456.00% | ||
|123456 | |||
|- | |- | ||
|# | |# | ||
| | |The # format specifier converts a number to a string. | ||
|1234 | |align="right"|1234 | ||
|- | |- | ||
|#.00 | |#.00 | ||
| | |The # format specifier converts a number to a string and using two fractional digits. | ||
|1234,56 | |align="right"|1234.56 | ||
|- | |||
|#,###.00 | |||
|The # format specifier converts a number to a string, using two fractional digits and the "," indicates a group separator. | |||
|align="right"|1,234.56 | |||
|- | |- | ||
|#,#.00 | |<nowiki>+#,##0.00%;-#,##0.00%;'∞'</nowiki> | ||
| | |This format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol,"+" indicates a positive number symbol and using two fractional digits. '∞' indicates 0. | ||
|1.234,56 | |align="right"|<nowiki>+1.234,56 / -1.234,56 / ∞</nowiki> | ||
|} | |} | ||
| Line 42: | Line 46: | ||
[[Category:Framework|Formatstrings]] | [[Category:Framework|Formatstrings]] | ||
[[Category:BI Center|Formatstrings]] | [[Category:BI Center|Formatstrings]] | ||
[[ | [[de:Framework:Zahlenformate]] | ||
Latest revision as of 09:38, 22 October 2015
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 ("n2") 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 |
| +#,##0.00%;-#,##0.00%;'∞' | This format specifier converts a number to a string of the form "-d,ddd,ddd.ddd…", where "-" indicates a negative number symbol,"+" indicates a positive number symbol and using two fractional digits. '∞' indicates 0. | +1.234,56 / -1.234,56 / ∞ |
