Print this page

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.

For Example:

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.

NOTE:

The formula syntax will depend on the field types that you would like to compare.




promote demote