3 years ago
Introducing Distribute() formula
Use DISTRIBUTE to recognise measures from a start and end date in months. Here are some use cases when to use it:
- Distribute a contract value paid up-front based on two dates
- Allocate a total expense amount by two dates
- Distribute a total amount between two dates to calculate the amount that you’ll bill each month
Note: Set your forecast or budget formula to “Same as actuals” to propagate the formula to your model.
Find an example here in the Abacum Academy.