---
title: "Custom Advanced Functions"
canonical: "https://wiki.yellowfinbi.com/space/user80/1541493/Custom%20Advanced%20Functions"
format: markdown
---
This guide will teach you how to create your own advanced functions and use them in reports.

 

## Overview

Advanced functions allow you to perform operations on top of report data after the primary SQL query has been run, unlike a calculated field, which is added to the report’s SQL statement. Functions can range from simple mathematical calculations and text manipulation, to more complex API calls with user input parameters.


## Guide Contents

This guide is broken into the following sections:


- [**Basics:**](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1541404) The basic process of creating a custom advanced function for Yellowfin reports. Start here if you are new to coding Yellowfin plug-ins.
- [**Advanced function creation:**](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1542049) The core methods required to code the function.
- [**Parameter set up: **](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1541389)Provide user input parameters such as radio buttons and drop down menus.
- [**Dependent parameter display: **](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1541395)Create dynamic interfaces by expanding upon the basic user input parameters.
- [**Data access and modification:**](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1541402) Use values from other columns, then return a customized result set.

 

For further reference, see the advanced function [appendix](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1542022).

 

 

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)