Documentation

Formulas

Dundas BI lets you apply mathematical formulas to data by entering small script-like expressions in a toolbar, similar to a desktop spreadsheet program. This article lists the built-in math functions that are available for use in formula expressions.

This walkthrough shows you how to use the Formula Visualization control and display the result in a Data Label control.

The AVG function computes the mean (or simple average) of a set of input values.

The Bollinger Bands function was developed by John Bollinger. It computes a pair of data bands that envelops a simple moving average of the input value series.

The Cumulative Total function computes the cumulative total (or running sum) of a set of input values.

The Exponential Moving Average function computes the average of a set of input values over a specified number of time periods.

The Historical Volatility function calculates the volatility of a set of input data values, such as stock prices over a period of time.

The Median function computes the median (e.g. middle) value from a set of input values.

The Mode function finds the value (or values) that is repeated more often than any other in a value series.

The Moving Average function computes the average of a set of input values over a specified number of time periods. The smaller the number of time periods, the faster the mpving average responds to changes in the input values.

The Moving Average Envelopes function computes a pair of data bands that envelops a moving average of the input data values.

The Percent of Total function returns the percentage of each value in the input series out of the total sum of the values in the input series.

The Sum function calculates the total sum for any number of input value series.

The Trend and Forecasting function applies a regression function to historical data in order to forecast future values based on the best fit.

The Weighted Moving Average function computes the average of a set of input values over a specified number of time periods.

The Correlation function calculates the correlation between two input data series.

The Normal Distribution function calculates the standard normal cumulative distribution for an input data series.

The Percentile function returns a scalar value below which the specified percentage of input data values fall.

The Histogram function assigns numeric values to bins and returns the counts.

The Percent Rank function calculates the percent rank for each value in a set of input values.

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri