# 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](/introduction/automate/functions-overview/transform-function-details/transform-custom-formula.md). 
   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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.k3-labs.com/introduction/automate/functions-overview/transform-function-details.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.