Can I add a formula field as a column in a report?
Currently, you can only add a formula field as a report column by selecting from one of the following predefined formats:
-
Sum: x+y
-
Difference: x-y
-
Percent Difference of X: ((x-y)/x)*100
-
Percent Difference of Y: ((x-y)/y)*100
-
Ratio: x/y
-
Percent Ratio: (x/y)*100
-
Multiply: x*y
These formulas use existing report columns as the x and y values. Reports currently don't support the addition of fields calculated through more complex, customized expressions, such as those that use SQL functions. Searches do support the use of these types of formulas for results and criteria fields.
See the following topics.