# Advanced Expression Piping

- Advanced Expression Piping (AEP): Overview
- AEP Grid Indexing: Overview
- How to use In-Form Piping
- How to Troubleshoot your AEP
- 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 Convert a Value to a Precise Floating Point (PRECISION)
- 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)