Template:Cell Formatting

From dataZoa Wiki
Revision as of 12:24, 16 January 2018 by SNC (Talk | contribs)

Jump to: navigation, search
FieldsDescriptionExamples
Styling
Min DecimalsMinimum number of decimals to show2 for U.S. Currency
Max DecimalsMaximum number of decimals to show2 for U.S. Currency
Percentage DecimalsExact number of decimals to show
in fields that are calculated as percentages
within the display itself.		2 for 1.23%
PrefixText to use before the number$
Yen:
SuffixText to use after the number(USD)
(thous.)
%
Scale
Multiply byNumber100, to express a percentage
Divide byNumber1000 for currency in thousands
AddNumber1.7, to add an integration constant
SubtractNumber1, to zero-base an index
+ / -
Parens when < 0CheckboxFinancial negative
Color when < 0HTML color nameRed
Color when > 0NumberBlue
Other
NDText to use when No DataNo data exists
N/AText to use when Not AvailableNo data available
NDDText to use when Not DisclosedUndisclosed
CommasCheckbox, use comma separatorFinancial information
Swap comma/periodCheckbox, European-style separatorsEuropean financial information
Retrieved from "https://docwiki.datazoa.com/index.php?title=Template:Cell_Formatting&oldid=3792"