Integer Format

The :integer format removes decimals and adds thousands separators for clean whole numbers.

Interactive Example

Try It

TABLE
  ROWS occupation * gender
  COLS education * income.sum:integer
;

Dataset:samplesoccupation, education, gender, income

Try Variations

Query Breakdown

• income.sum:integer - Formats the sum as a whole number with commas (1,235)
• Decimals are rounded to the nearest whole number
• Thousands separators make large numbers readable

Use :integer when decimal precision is not needed, such as for counts, population figures, or rounded totals.

Related Examples

• Currency - Dollar formatting
• Decimal - Control decimal precision
• Multiple Formats - Different formats per measure
• Custom Format - Custom format strings