Planning requires various types of calculations. To perform these calculations, you can use advanced data actions (formulas).

Here are some key points regarding advanced formulas:

Use Cases:

- Advanced formulas provide a mechanism for custom calculation logic
- Driver-based formulas: Rev = Price x Qty
- Depreciation calculation
- Populate opening balances for headcounts
- Mark-ups | Mark-downs
- Schedule or run on an ad-hoc basis

Maintenance:

- The script editor provides context help and code completion
- Validation and trace mode in the script editor

Features:

- The visual editor provides a graphical wizard to define calculation logic
- The statements are represented by boxes, which can be further configured with special dialogs
- The graphical representations give users a clear logic flow

Note

Advanced data actions are used to perform calculations that are stored in the database. If there's a need to perform calculations that aren't stored in the database, there are several options:- Data table formulas
- Story-based calculated measures
- Model-based calculated measures