You are able to create formulas that can be inserted into a report.

List of XpandedReports Functions

Steps in creating a new formula

1. Report:  Once a report is displayed, select the fx symbol on the report header, next to the Refresh button.
   
   The following dialog will be displayed:

   

   
   
2. Label:  Enter the Label. This Label will be used as your reference for future use.
   
   
3. Enter Expression:  Create the formula. (Example: [Amount]*[Rate] ).
   
   
4. Format:  Select the data type format to be displayed. (Example:  Currency for commissions).
   
   
5. Ttutorial:  Example of inserting a Excel type formula directly into the report.