Formula Column
- Math Functions:
- Addition, Subtraction, Multiplication, Division: Used for calculations like sales totals, discounts, commissions, etc.
- Average, Sum, Min, Max: Aggregating values across records or fields.
- String Functions:
- Concatenation: Combine text fields, such as first and last names or address components.
- Substrings: Extract parts of a text field for specific uses.
- Date Functions:
- Date Difference: Calculate differences between dates (e.g., days open for a case).
- Add/Subtract Days: Compute future or past dates from a given date.
- Logical Functions:
- IF Statements: Create conditional logic for decisions based on field values.
- AND/OR: Combine multiple conditions for complex logic.
- Comparison Functions:
- Greater Than, Less Than, Equals: Perform comparisons for filtering or categorization.