- Mathematical operations, logical operators
- Filling null values
- Aggregating & disaggregating
- Aggregating Product, creating Index
- Forecast
- Mathematical functions
For more examples see All about counting observations.
Mathematical operations, logical operators
Whole list of operators can be found under The Macrobond formula language.
Operators - add, subtract, multiply, divide
Operators - or, and, equal, not equal, not
Filling null values
When series has empty points in time there are a few ways to fill them in.
Aggregating & disaggregating
You can aggregate series with analysis but also with formulas.
AggregateSum - monthly and quarterly
Aggregating Product, creating Index
AggregateProduct - from YTD PY=100 to Index
Forecast
Some series have forecast. With some formulas you can calculate only on historical or on estimated values.
Identifying forecast and removing it