# Form Calculations (AEP)

- How to Create Calculations in your Forms
- Indexing your Form Fields for Calculations
- How to use In-Form Piping
- How to Troubleshoot your Form Calculations
- How to Calculate the Sum (SUM)
- How to Calculate the Average (AVG)
- How to Find the Largest Value (MAX)
- How to Find the Smallest Value (MIN)
- How to Concatenate Values in a Form (CONCAT)
- How to Return the First Input Value (COALESCE)
- How to Convert a Floating Point to an Integer (INT)
- How to Convert Values to a String (STR)
- How to Convert a Value to a Single Floating Point (REAL)
- How to Convert a Value to Two Floating Points (REALTWO)
- How to Generate a Random Number between Two Values (RANDIT)
- How to Find the Index of a Character within a String (INDEXOF)
- How to Return a Substring of Characters from a String (SUBSTR)