You are able to create formulas that can be inserted into the report using Excel type functions.

Excel functions

XpandedReports supports many of the Excel functions.  List of XpandedReports Functions

The following link is a sample of creating conditional formulas with Excel on Microsoft Office website.

Steps in creating a new formula

1. Select report:  From the XpandedReports menu, select the report you would like to include an Excel formula..
   
   
2. Modify report:  Select the Computed Column tab on the Modify Report's display. The Computed Column tab is an additional tab that XpandedReports provides. .
   
   

   

3. Label:  Enter the Label. This Label will be used as your reference for future use. .
   
   
4. Enter Expression:  Create the formula using Excel functions. You choose a combination of functions and fields in two drop down menus..
   
   
5. Format:  Select the data type format to be displayed. (Example:  Currency for commissions).
   
   
6. Validate:  Click the Validate button to determine if the calculation displays the desired information..
   
   
7. Memorize:  Once you have validated the formula, you select Memorize to save the formula using the Label you prescribed. You should see the new formula listed below in the Memorized Calculations..
   
   
8. Display:  The new expression Label will be visible on the Display tab page..
   
   
9. Select:  Check the Select box to add the new expression to your report..
   
   

For more information, see the Computed Columns Tab demo.