Working with Formulas (Report Builder)
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)