Calculations Features and Functions

• Multiple aggregation functions: sum, min, max, count, and others


• Calculated facts, based on predefined functions or user-defined formulas


• Multidimensional formula language allows to operate with totals, subtotals, and any elements of cube data


• Conditional operators, built-in functions, user-defined functions and constants in formulas


• Bases multiple calculated facts on other calculated facts


• Interactive Excel-like custom formula definition


• Several types of count algorithms, e.g,. records count, count in group, child count, leaf count


• Several percentage calculation algorithms, e.g., by totals, subtotals, or grand totals


• The unique "last" aggregation algorithm, ideal to analyse stocks, inventory stock, balance sheets, loan balance and other datasheets with balance carried forward


• Advanced dynamic ranking


• Breaks date and time fields into series dimensions (year, quarter, month, week, ten-day period, day of month, day of week, time, hour, minute, second )


• Date and time-based calculations, such as trend, variance, and cumulative sum functions


• Dynamically calculates statistic functions e.g., average, variance, standard deviation, root mean square, variance ratio