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

Dimensional

BY modifier

By mapping parameter -> "Arrow"

ADD modifier

Logical

Numeric

Text

Time and Date

Security

RESETACCESSRIGHTS function

ACCESSRIGHTS function

Aggregation

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

COUNTALLOF function

COUNTBLANKOF function

COUNTUNIQUEOF function

SUMOF function

Forecasting/Smoothing

FORECAST_ETS function

FORECAST_LINEAR function

SIMPLE_EXPONENTIAL_SMOOTHING function

DOUBLE_EXPONENTIAL_SMOOTHING function

SEASONAL_LINEAR_REGRESSION function

Finance

NPV function

XNPV function

IRR function

XIRR function

Statistical

STANDARD_NORMAL_DISTRIBUTION function

STANDARD_NORMAL_DISTRIBUTION_CUMULATIVE function

Numeric Functions

Product

Use Cases

Resources

Company

Follow