Make sure that you are familiar with Formula Reference Guide prior to proceeding with Formula Use Cases.
Formulas are very powerful and complex scripting language. You can conduct wide variety of calculations and transformations by using and combining advanced functions.
In the following sections, you can find advanced Use cases and detailed description of the most common tasks conducted in BellaDati simply by using Formulas.
Current Use cases include:
- Filtering in Formulas
- Calculating Frequencies
- Calculating Percentual Share in Drill-Downs
- Calculating With Members On Defined Level
- Calculating Average Cumulated Values
- Calculating Percentiles and Quantils
- Getting Last Available Value
- Cross-referencing Values from Different Data Set
- Handling empty (NULL) values by formulas
- Representing numbers in accounting format
- How to display calculated indicator in number of days order rather than date
You can request help or additional use cases by contacting BellaDati analysts team at support@belladati.com
Next Steps
- Filtering in Formulas
- Calculating Frequencies
- Calculating Percentual Share in Drill-Downs
- Calculating With Members On Defined Level
- Calculating Average Cumulated Values
- Calculating Percentiles and Quantils
- Getting Last Available Value
- Cross-referencing Values from Different Data Set
- Handling empty (NULL) values by formulas
- Representing numbers in accounting format
- How to display calculated indicator in number of days order rather than date
Overview
Content Tools