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
![Advanced formula options for data actions in SAP Analytics Cloud. The step is selected on the left and the configuration options are displayed on the right. Advanced formula options for data actions in SAP Analytics Cloud. The step is selected on the left and the configuration options are displayed on the right.](/service/media/topic/f3af9e69-45cd-4197-bbe9-0e6353dcfcdd/SACP21_39_en-US_media/SACP21_39_en-US_images/U3L2_AdvFormRecap_SS_C.png)
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