---
title: "Functions and Dimension modifiers"
slug: "functions"
description: "This section lists all Pigment's functions within categories."
updated: 2026-04-24T15:29:06Z
published: 2026-04-24T15:29:06Z
canonical: "kb.pigment.com/functions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Functions and Dimension modifiers

Sometimes it is hard to find the formula you are looking for. This section covers all Pigment’s functions, which are sub-divided below.

## Dimension modifiers

| [ADD modifier](/v1/docs/add-modifier) |
| --- |
| [REMOVE modifier](/v1/docs/remove-modifier) |
| [KEEP modifier](/v1/docs/keep-modifier) |
| [FILTER modifier](/v1/docs/filter-modifier) |
| [EXCLUDE modifier](/v1/docs/exclude-modifier) |
| [BY modifier](/v1/docs/by-modifier) |
| [SELECT modifier](/v1/docs/select-modifier) |
| [TOPARENTLIST modifier](/v1/docs/toparentlist-modifier) |
| [TOSUBSET modifier](/v1/docs/tosubset-modifier) |

## Mapping and reference functions

| [ITEM function](/v1/docs/item-function) |
| --- |
| [MATCH function](/v1/docs/match-function) |
| [FILLFORWARD function](/v1/docs/fillforward-function) |
| [TIMEDIM function](/v1/docs/timedim-function) |
| [SHIFT function](/v1/docs/shift-function) |

## Logical

| [ANYOF function](/v1/docs/anyof-function) |
| --- |
| [SWITCH function](/v1/docs/switch-function) |
| [AND function](/v1/docs/and-function) |
| [OR function](/v1/docs/or-function) |
| [NOT Function](/v1/docs/not-function) |
| [IF function](/v1/docs/if-function) |
| [TRUE function](/v1/docs/true-function) |
| [ISBLANK function](/v1/docs/isblank-function) |
| [ISNOTBLANK function](/v1/docs/isnotblank-function) |
| [ISDEFINED function](/v1/docs/isdefined-function) |
| [IN function](/v1/docs/in-function) |
| [IFBLANK function](/v1/docs/ifblank-function) |
| [FALSE function](/v1/docs/false-function) |
| [IFDEFINED function](/v1/docs/ifdefined-function) |

## Numeric

| [SIGN function](/v1/docs/sign-function) |
| --- |
| [EXP function](/v1/docs/exp-function) |
| [LN function](/v1/docs/ln-function) |
| [LOG function](/v1/docs/log-function) |
| [SIN function](/v1/docs/sin-function) |
| [COS function](/v1/docs/cos-function) |
| [SQRT function](/v1/docs/sqrt-function) |
| [MIN function](/v1/docs/min-function) |
| [MAX function](/v1/docs/max-function) |
| [MOD function](/v1/docs/mod-function) |
| [QUOTIENT function](/v1/docs/quotient-function) |
| [POWER function](/v1/docs/power-function) |
| [ROUND function](/v1/docs/round-function) |
| [ROUNDDOWN function](/v1/docs/rounddown-function) |
| [ROUNDUP function](/v1/docs/roundup-function) |
| [TRUNC function](/v1/docs/trunc-function) |
| [CEILING function](/v1/docs/ceiling-function) |
| [FLOOR function](/v1/docs/floor-function) |
| [RANK function](/v1/docs/rank-function) |
| [SPREAD function](/v1/docs/spread-function) |
| [CUMULATE function](/v1/docs/cumulate-function) |
| [DECUMULATE function](/v1/docs/decumulate-function) |
| [ABS function](/v1/docs/abs-function) |
| [TEXT function](/v1/docs/text-function) |

## Text

| [CONTAINS function](/v1/docs/contains-function) |
| --- |
| [STARTSWITH function](/v1/docs/startswith-function) |
| [ENDSWITH function](/v1/docs/endswith-function) |
| [LEN function](/v1/docs/len-function) |
| [LEFT function](/v1/docs/left-function) |
| [MID function](/v1/docs/mid-function) |
| [RIGHT function](/v1/docs/right-function) |
| [LOWER function](/v1/docs/lower-function) |
| [UPPER function](/v1/docs/upper-function) |
| [TRIM function](/v1/docs/trim-function) |
| [VALUE function](/v1/docs/value-function) |
| [PROPER function](/v1/docs/proper-function) |
| [FIND function](/v1/docs/find-function) |
| [& function](/v1/docs/function) |
| [SUBSTITUTE function](/v1/docs/substitute-function) |

## Time and Date

| [MAX function](/v1/docs/max-function) |
| --- |
| [DATE function](/v1/docs/date-function) |
| [DATEVALUE function](/v1/docs/datevalue-function) |
| [EOMONTH function](/v1/docs/eomonth-function) |
| [MIN function](/v1/docs/min-function) |
| [STARTOFMONTH function](/v1/docs/startofmonth-function) |
| [WEEKDAY function](/v1/docs/weekday-function) |
| [DAY function](/v1/docs/day-function) |
| [MONTH function](/v1/docs/month-function) |
| [MONTHDIF function](/v1/docs/monthdif-function) |
| [YEAR function](/v1/docs/year-function) |
| [DAYS function](/v1/docs/days-function) |
| [NETWORKDAYS function](/v1/docs/networkdays-function) |
| [INPERIOD function](/v1/docs/inperiod-function) |
| [DAYSINPERIOD function](/v1/docs/daysinperiod-function) |
| [TIMEDIM function (Time & Date)](/v1/docs/timedim-function-timedate) |
| [PRORATA function](/v1/docs/prorata-function) |
| [MONTHTODATE function](/v1/docs/monthtodate-function) |
| [QUARTERTODATE function](/v1/docs/quartertodate-function) |
| [YEARTODATE function](/v1/docs/yeartodate-function) |
| [MOVINGAVERAGE function](/v1/docs/movingaverage-function) |
| [MOVINGSUM function](/v1/docs/movingsum-function) |
| [EDATE function](/v1/docs/edate-function) |
| [PREVIOUS function](/v1/docs/previous-function) |
| [PREVIOUSOF function](/v1/docs/previousof-function) |
| [PREVIOUSBASE function](/v1/docs/previousbase-function) |

## Security

| [RESETACCESSRIGHTS function](/v1/docs/resetaccessrights-function) |
| --- |
| [ACCESSRIGHTS function](/v1/docs/accessrights-function) |

## Aggregation

*(note: these functions only return a number without any Dimensions)*

| [COUNTALLOF function](/v1/docs/countallof-function) |
| --- |
| [COUNTBLANKOF function](/v1/docs/countblankof-function) |
| [COUNTUNIQUEOF function](/v1/docs/countuniqueof-function) |
| [SUMOF function](/v1/docs/sumof-function) |
| [AVGOF function](/v1/docs/avgof-function) |
| [MINOF function](/v1/docs/minof-function) |
| [MAXOF function](/v1/docs/maxof-function) |
| [COUNTOF function](/v1/docs/countof-function) |

## Forecasting/Smoothing

| [FORECAST_ETS function](/v1/docs/forecast-ets-function) |
| --- |
| [FORECAST_LINEAR function](/v1/docs/forecast-linear-function) |
| [SIMPLE_EXPONENTIAL_SMOOTHING function](/v1/docs/simple-exponential-smoothing-function) |
| [DOUBLE_EXPONENTIAL_SMOOTHING function](/v1/docs/double-exponential-smoothing-function) |
| [SEASONAL_LINEAR_REGRESSION function](/v1/docs/seasonal-linear-regression-function) |

## Finance

| [NPV function](/v1/docs/npv-function) |
| --- |
| [XNPV function](/v1/docs/xnpv-function) |
| [IRR function](/v1/docs/irr-function) |
| [XIRR function](/v1/docs/xirr-function) |

## Statistical

| [STANDARD_NORMAL_DISTRIBUTION function](/v1/docs/standard-normal-distribution-function) |
| --- |
| [STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function](/v1/docs/standard-normal-distribution-function) |