Decimal

✓ functional

Show the precision, rounding, and currency cues that make fractional values make sense.

For fractional values, Settings › Results › Decimal lets you choose a presentation that matches the people reading the result.

OptionChoicesDefault
Decimal placesFixed precision6
Thousands separatorsOn / offOn
Decimal separatorPeriod (1.23) / Comma (1,23)Period
Thousands separatorComma / Period / Space / Apostrophe / NoneComma
Reduce large numbersAbbreviate to K / M / G / T / P (with threshold)Off
Negative formatMinus sign / ParenthesesMinus sign
AlignmentLeft / Center / Right-
Currency and percent are per-column choices, not decimal defaults. Apply them with a Number override using fixed, percent, or bytes styles.
SQLly
SQLly decimal formatting configuration panel
The decimal formatting panel in Settings.