Decimal

Definition of Decimal, a data type, with examples and typical usage in sorts and filters.

In object-oriented programming, structured databases, and CRMs, fields/attributes/columns will often have defined Attribute Data Types.

Definition(s)

• Decimal (also known as Float also known as Numeric also known as Percent) is a data type found in our Objects, Lists, List Columns, and Outbounding Metrics

• Decimal allows for math operations

• Decimal allows for whole numbers and fractional, decimal numbers. Typically, the number of digits after the period is predetermined when determining the decimal precision.

Examples

• A field called "Price" in a table that needs cents instead of rounded whole dollars.

• A field called "Qualified Meeting Rate" in a table which is a percentage.

Typical Usage in Sorts & Filters

• Sorting Decimal will typically involve sorting largest to smallest, or smallest to largest.

• Filtering Decimal typically provides the following options:

  • 'is exactly' aka 'exactly matches' aka 'is equal to' aka '=' aka 'is' aka 'equals'

  • 'is not' aka 'does not exactly match' aka 'is not equal to' aka '!=' aka '<>' aka 'does not equal'

  • 'greater than' aka 'is greater than' aka '>'

  • 'less than' aka 'is less than' aka '<'

  • 'greater than or equal to' aka 'is greater than or equal to' aka '>=' aka 'at least'

  • 'less than or equal to' aka 'is less than or equal to' aka '<=' aka 'at most'

  • 'is between'