Numerical Fields in SomaDB

Numerical fields are designed to handle various types of numeric data, from simple integers to precise decimal values and formatted currency. Each type provides appropriate validation, formatting, and calculation capabilities.

Numerical Field Types

Number

• Use Case: Integers, counts, quantities
• Features: Whole number input with validation
• Validation: Integer values, range limits

Decimal

• Use Case: Precise measurements, calculations
• Features: Decimal number input with precision control
• Validation: Decimal values, precision limits

Percent

• Use Case: Percentages, ratios, completion rates
• Features: Percentage formatting and display
• Validation: 0-100% range, decimal precision

Currency

• Use Case: Prices, costs, financial data
• Features: Currency formatting and symbols
• Validation: Positive values, currency codes

Key Features

• Precision Control: Set decimal places and rounding
• Formatting Options: Customize number display
• Validation Rules: Range limits and value constraints
• Calculation Support: Use in formulas and calculations

Best Practices

• Choose appropriate precision for your data
• Use currency fields for financial data
• Set validation rules to ensure data quality
• Consider formatting for better readability

Next Steps

Explore each numerical field type to learn more about their specific features and use cases.