Difference between revisions of "Template:Cell Formatting"

Revision as of 12:23, 16 January 2018

	Fields	Description	Examples
Styling
	Min Decimals	Minimum number of decimals to show	2 for U.S. Currency
	Max Decimals	Maximum number of decimals to show	2 for U.S. Currency
	Percentage Decimals	Exact number of decimals to show in fields that are calculated as percentages by the display itself.	2 for 1.23%
	Prefix	Text to use before the number	$ Yen:
	Suffix	Text to use after the number	(USD) (thous.) %
Scale
	Multiply by	Number	100, to express a percentage
	Divide by	Number	1000 for currency in thousands
	Add	Number	1.7, to add an integration constant
	Subtract	Number	1, to zero-base an index
+ / -
	Parens when < 0	Checkbox	Financial negative
	Color when < 0	HTML color name	Red
	Color when > 0	Number	Blue
Other
	ND	Text to use when No Data	No data exists
	N/A	Text to use when Not Available	No data available
	NDD	Text to use when Not Disclosed	Undisclosed
	Commas	Checkbox, use comma separator	Financial information
	Swap comma/period	Checkbox, European-style separators	European financial information

@@ Line 4: / Line 4: @@
 <tr><td></td><td>Min Decimals</td><td>Minimum number of decimals to show</td><td>2 for U.S. Currency</td></tr>
 <tr><td></td><td>Max Decimals</td><td>Maximum number of decimals to show</td><td>2 for U.S. Currency</td></tr>
+<tr><td></td><td>Percentage Decimals</td><td>Exact number of decimals to show in fields that are calculated as percentages by the display itself.</td><td>2 for 1.23%</td></tr>
 <tr><td></td><td>Prefix</td><td>Text to use before the number</td><td>$<br>Yen: </td></tr>
 <tr><td></td><td>Suffix</td><td>Text to use after the number</td><td>(USD)<br>(thous.)<br>%</td></tr>