Working with Formulas (Report Builder 1.0)
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
SUM(IF(Finished Goods Flag, "Finished", "Unfinished"))
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.