Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Formulas are calculations performed on values in your report. Sometimes, they are referred to as expressions. A formula can contain functions, operators, constants, and references to fields or entities. You do not need to add an equals sign (=) to a formula in Report Builder because it is implicitly stated.
Formulas can look similar to any of the following:
- Sum Line Total
- 6+12
- SUM(IF(Finished Goods Flag, "Finished", "Unfinished"))
In This Section
| Topic | Description |
|---|---|
Discusses how to create a new field and assign a formula. |
|
Discusses how to create a formula. |
|
Discusses how to manipulate formulas by aggregating, filtering, and removing duplicates. |
|
Discusses the functions available in Report Builder. |
See Also
Tasks
How to: Add or Change a Formula (Report Builder)
Concepts
Working with Data (Report Builder)
Working with Literals in Formulas and Filters (Report Builder)