Log in
Skip to sidebar
Skip to main content
Linked Applications
Loading…
BellaDati Support & Documentation
Spaces
Hit enter to search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log in
BellaDati User Documentation
Search
Page tree
Browse pages
Configure
Space tools
View Page
A
t
tachments (6)
Page History
Page Information
View in Hierarchy
View Source
Export to Word
Pages
…
BellaDati User's Documentation
Reports
Using Formulas and scripts
Formula Use Cases
Page Information
Title:
Formula Use Cases
Author:
Anonymous
Oct 15, 2012
Last Changed by:
Martin Trgiňa
Mar 01, 2022
Tiny Link:
(useful for email)
https://support.belladati.com/x/RgDN
Export As:
Word
Incoming Links
BellaDati User Documentation (8)
Page:
Accessing Report Variables
Page:
Referencing Data From Another Data Set
Page:
Datetime Constants
Page:
Datetime Functions
Page:
Special Functions
Page:
Formula Reference Guide
Page:
Using Formulas and scripts
Page:
Math Functions
Hierarchy
Parent Page
Page:
Using Formulas and scripts
Children (19)
Page:
Filtering in Formulas
Page:
Calculating Frequencies
Page:
Calculating Percentual Share in Drill-Downs
Page:
Calculating With Members On Defined Level
Page:
Calculating Average Cumulated Values
Page:
Calculating Percentiles and Quantils
Page:
Getting Last Available Value
Page:
Cross-referencing Values from Different Data Set (crossValue)
Page:
Handling empty (NULL) values by formulas
Page:
Representing numbers in accounting format
Show all...
Page:
Overriding Date Interval with Day Order
Page:
Displaying text values in KPI labels
Page:
Display Top or Bottom Member Value in KPIs
Page:
Calculating average across different drill down levels
Page:
Calculate revenue using unit price times quantity and revenue percentage
Page:
Calculating with NULL values
Page:
Link Relative Ratio and Year-on-year Comparison
Page:
Calculating Yearly Cumulated Values
Page:
Creating Pareto Chart
Hide...
Labels
Global Labels (1)
formula
Recent Changes
Time
Editor
Mar 01, 2022 18:18
Martin Trgiňa
View Changes
Removed translated content for 'cs'
Mar 01, 2022 18:09
Martin Trgiňa
View Changes
Removed translated content for 'zh'
Aug 15, 2019 01:15
Kanako Higashi
View Changes
Aug 15, 2019 01:09
Kanako Higashi
View Changes
Jun 03, 2019 06:54
Claudio Toscani
View Page History
Outgoing Links
External Links (1)
mailto:support@belladati.com
BellaDati User Documentation (1)
Page:
Formula Reference Guide
Overview
Content Tools
{"serverDuration": 104, "requestCorrelationId": "e3b3e399667ff1c3"}