# Transform Function Details

**Overview**

The Transform Function in K3 Labs is designed to enable users to manipulate and process data in workflows with a range of customizable options. Below, you can find a breakdown of how the function setup and key features work.

\
**Setup Components:**

1. Field Selector: Allows users to select fields for formula creation, similar to the IF function.
2. Variable Field: A variable selector allowing users to add input points into their formulas.

Note: One transform function can perform one action.

\
**Formula Functions:**

Upon selecting the formula option, users can choose from a drop-down menu with various mathematical, string, and array operations, categorized as follows:

1. Math Operations
   1. Custom Formula: Allows for custom formulas. See more [here](https://docs.k3-labs.com/introduction/automate/functions-overview/transform-function-details/transform-custom-formula). 
   2. Abs: Returns the absolute value.
   3. Average: Calculates the average of a set of numbers.
   4. Floor: Rounds a number down to the nearest integer.
   5. Median: Finds the median value in a set of numbers.
   6. Mod: Returns the remainder from a division.
   7. Rand: Generates a random number.
   8. Min: Returns the smallest value from a set of inputs.
   9. Max: Returns the largest value from a set of inputs.
   10. Power: Raises x to the power of y (i.e., computes x^y).
   11. Percentage Change:  Calculates the percentage change from a to b, using the formula ((b - a) / a) \* 100.
2. String Functions
   1. Length: Returns the length of a string.
   2. LowerCase: Converts text to lowercase.
   3. UpperCase: Converts text to uppercase.
   4. REGEX\_Replace: Replaces a substring using regular expressions.
   5. Replace: Replaces occurrences of a string with another string.
   6. Substring: Extracts a portion of a string.
   7. Trim: Removes leading and trailing spaces.
   8. TrimLeft: Removes spaces from the beginning of a string.
   9. TrimRight: Removes spaces from the end of a string.