# Formulas and Functions

> The Data Browser enables you to use formulas (freeform expressions) to determine the values and filters of a widget. A rich variety of functions is provided for your use in formulas.

*Source: https://docs.sisense.com/main/SisenseLinux/formulas-and-functions.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

Formulas and functions are powerful tools in Sisense that allow you to transform raw data into meaningful metrics, calculations, and analytical insights. Whether you’re building KPIs, customizing widget behavior, or defining complex analytical logic, formulas give you the flexibility to shape your data exactly the way you need.

Sisense offers a rich formula editor, a comprehensive library of built-in functions, and support for advanced capabilities such as conditional logic, multipass aggregation, and even R-based expressions. You can create formulas directly within widgets, reuse them across dashboards, or define shared formulas for consistent logic throughout your analytics environment.

This section introduces the full ecosystem of Sisense calculation features, including how to:

- [Create and edit formulas](https://docs.sisense.com/main/SisenseLinux/creating-and-editing-a-formula.md) within widgets
- Build [reusable](https://docs.sisense.com/main/SisenseLinux/reusing-formulas.md) and [shared](https://docs.sisense.com/main/SisenseLinux/shared-formulas.md) formulas for consistent analytics
- Apply [conditional statements and criteria-based logic](https://docs.sisense.com/main/SisenseLinux/creating-formulas-based-on-criteria-and-conditions-filters.md)
- Work with [measured values](https://docs.sisense.com/main/SisenseLinux/measured-values.md) and [multipass aggregation](https://docs.sisense.com/main/SisenseLinux/multipass-on-measured-value.md)
- [Use R](https://docs.sisense.com/main/SisenseLinux/using-r-in-formulas.md) for advanced statistical or custom computations
- Explore the [complete library of functions](https://docs.sisense.com/main/SisenseLinux/dashboard-functions-reference.md) and [quick functions](https://docs.sisense.com/main/SisenseLinux/quick-functions.md) available in Sisense

Use these topics to learn how formulas and functions can enhance your dashboards, enrich your data analysis, and unlock deeper insights across your Sisense environment.