How to compare field values with each other in Reports
|Knowledge Article Number||000239952|
|Description||Currently we cannot use any filter in Reports to compare two field values.
Amount >= Annual Amount
|Resolution||To achieve this request we can use the following workaround:
1) Create a custom formula field on the object that you want to report on. Use the below Formula:
IF(fieldname1 = fieldname2, 1, 0)
2) Then in your report you can set the newly created formula field as your filter criteria. The formula will display record by record.
The formula syntax will depend on the field types that you would like to compare.