Numeric format

In the dialog is shown a list of the numeric format ready to use an a Custom section to write a personalized format. The formats ready to use are:

Format		Description	12345.67	-12345.67
---		Raw database format, defined in cube	12346	-12345
#		Only numbers are shown	12346	-12345
#.##		Two decimal digits	12345.67	-12345.67
#,##0		Coma separator in thousands	12,346	-12,345
(#,##0)		Negative parenthesis	12,346	(12,345)
#,##0.00			12,345.67	-12,345.67
(#,##0.00)			12,345.67	(12,345.67)
$#, ##0		Dollar or money sign (as established by windows)	$12,346	-$12,345
($#,##0)			$12,346	($12,345)
$#,##0.00			$12,345,67	-$12,345.67
($#,##0.00)			$12,345.67	($12,345.67)
Percentage		Percentages format. The number gets multiplies by 100 (%)	.074
0%		None	7%
00%		Cero justified	07%
0.00%		Two decimal digits	7.40%
00.00%			07.40%
Format in thousands		Formats showing information in thousands (,.)	12345.67
#,##0,.		Number divided by 1000	12.	-12.
(#,##0,.)			12.	(12.)
#,##0,.00			12.35	-12.34
(#,##0,.00)			12.35	(12.34)

The  Custom format lets you establish the format that you want. You can use the characters #, 0, $, (), ,, ., ,., % to create new formats. You also can experiment with other characters.

If you wish to apply your changes, your cube view will look like this: