Standard Functions

The standard functions in this chapter range from simple operations like Sum and Product to internal functions that allow you to define your own metrics, facts, and filters. Taken as a set, they provide a powerful toolset for performing common mathematical calculations, grouping data, examining correlation, validating data, and formatting report information for display.

Each section in this chapter describes a function category and presents a list of functions within each category. Each section also presents the data necessary to understand and implement each individual function. The information provided for each function includes

• An explanation of the data returned by the function
• The syntax of the function including function name, available parameters, the parameter setting defaults, and the types of data that can be used with the function
• The mathematical expression illustrating exactly how the calculation is defined in MicroStrategy (if applicable)
• Usage notes describing any error conditions, invalid data types, or key information to know before using the function (if applicable)
• An example of the function in use; this may be either a report example or a simple text description of the data returned based on the specified input