-
Formula and Function Resources
Summary: This lesson reviews key resources available for Model Builders to learn more about using Anaplan's functions in formulas. Audience: Model Builders Lesson Duration: 2 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the Micro-lesson:…
-
Copying a Module
Summary: This lesson reviews the options available to Model Builders when copying a module. Audience: Model Builders Lesson Duration: 2 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the Micro-lesson: 日本語版マイクロレッスンを開始する: For training purposes…
-
Avoiding Hard Coding
Summary: This lesson reviews best practices to avoid hard coding when creating formulas to improve the adaptability of the model over time. Audience: Model Builders Lesson Duration: 4 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the…
-
Using the SUM Function
Summary: This lesson describes the purpose and use of Anaplan's SUM function to aggregate values of items that meet one or more specific criteria. The lesson also provides a guided practice activity. Audience: Model Builders Lesson Duration: 8 minutes Lesson Location: This micro-lesson is also available in the Level 1…
-
Using the LOOKUP Function
Summary: This lesson describes the purpose and use of Anaplan's LOOKUP function in model formulas to map source data in another line item to the target of the formula. Audience: Model Builders Lesson Duration: 15 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in…
-
Creating System Modules
Summary: This lesson shares the recommended best practices for using and building system modules in a model to hold functions and data that are referenced by input, calculation, and output modules. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model…
-
Time Functions
Summary: This lesson reviews Anaplan's time series and non-time series functions used for time-based calculations. Audience: Model Builders Lesson Duration: 2 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the Micro-lesson: 日本語版マイクロレッスンを開始する:…
-
Build a Time System Module
Summary: This lesson reviews recommendations for creating a system module in a model to perform time calculations that can be referenced in formulas throughout the model. Audience: Model Builders Lesson Duration: 4 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in…
-
Summary Settings
Summary: This lesson reviews the Summary Method settings and considerations for selecting the best option for the module data. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the Micro-lesson:…
-
Best Practices for Formulas with References
Summary: This lesson describes recommended best practices and techniques to make creating formulas that reference data throughout the model easier. Audience: Model Builders Lesson Duration: 3 minutes Lesson Location: This micro-lesson is also available in the Level 1 Model Building course in the Learning Center. Start the…