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 (crossValue)
- Handling empty (NULL) values by formulas
- Representing numbers in accounting format
- Overriding Date Interval with Day Order
- Displaying text values in KPI labels
- Display Top or Bottom Member Value in KPIs
- Calculating average across different drill down levels
- Calculate revenue using unit price times quantity and revenue percentage
- Calculating with NULL values
- Link Relative Ratio and Year-on-year Comparison
- Calculating Yearly Cumulated Values
- Creating Pareto Chart
You can request help or additional use cases by contacting BellaDati analysts team at support@belladati.com
Overview
Content Tools