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.