-
Course Prep Checklist 0 hr 10 min
-
Introduction 0 hr 2 min
-
Pigment Fundamentals recap 0 hr 10 min
-
Formula Structure and Syntax 0 hr 4 min
-
Using Modifiers in Formulas: Introduction 0 hr 7 min
-
Using Modifiers in Formulas: ADD 0 hr 2 min
-
Using Modifiers in Formulas: REMOVE 0 hr 1 min
-
Using Modifiers in Formulas: BY 0 hr 3 min
-
Using Modifiers in Formulas: FILTER, EXCLUDE, and SELECT 0 hr 2 min
-
Get hands-on: Create a Staff Costs Application 1 hr 0 min
-
Resources 0 hr 1 min
-
Share your feedback!
-
Knowledge check 0 hr 15 min
Build Formulas in Pigment
Explore structure and syntax, object references, filtering, aggregation and allocation
In this course, you learn how to:
- Identify the structure and syntax of Pigment formulas
- Differentiate between Excel and Pigment formulas
- Reference objects in formulas
- Reference list properties in formulas
- Filter data in formulas
- Explain aggregation in formulas
- Explain allocation in formulas
- Identify the most used functions, operators and modifiers in formulas
- Create an aggregated view of metrics