Overview

Dundas Chart for SharePoint™ provides you with many formulas to use in your charting web part. To effectively use any of the formulas provided, you must understand how, and which, parameters to use with that formula. Since every formula is unique, a series of formula specific links have been provided for you later in this article under the heading Formula Specific Information.

This formula reference has been included to give you a complete listing of every available formula that can be used in Dundas Chart for SharePoint™. As you will see, there is a lot of information to cover, and a multitude of formulas to use in your charting applications. Give the size of this reference, some common points that apply equally to all formulas are mentioned here, rather than repeating the same items in each of the topics covered.

Within the Formula Reference you will find two main categories of formulas, Financial Formulas and Statistical Formulas. There are some commonalities between these two formula categories, and these commonalities will affect how you use formulas with Dundas Chart for SharePoint™, and in general. These commonalities will be addressed herein under the heading Formulas - Common Points. Immediately following this section, there are sections for each of the two formula categories describing information to note for that category as a whole.

For more information on using financial formulas, refer to the topic on Using Financial Formulas.

For more information on using statistical formulas, refer to the topic on Using Statistical Formulas.

All Formulas - Common Points

The following list of points applies to all formulas found in the Formulas Reference:

We recommend that you read Using Financial Formulas before proceeding any further. The topic on using financial formulas explains the many options available to you when applying a formula.
Before applying any one of the formula methods, make sure that all data points have their XValue property set, and that the series' XValueIndexed property has been set to false.

Financial Formulas

The following applies to all formulas found in the Financial Formulas category:

All formulas are calculated using the FormulaFinancial method, which accepts the following types of arguments: a formula name, an input value(s), an output value(s), and parameter(s). The parameters used however, are specific to the type of formula being applied.