Make the best use of Salesforce reports with this feature. You can compare the values of two different report fields and return records that satisfy the comparison criteria with a field-to-field filter.
Let’s take an example.
You want to report on opportunities and want to show records in the report where the Amount is less than the projected amount. Means, opportunities worth less than projected. A typical way to do this is to create a formula field on the Opportunity object to return true or false based on a comparison of two fields or have a row-level formula field on the report to return value. In both cases, you need to create an extra field to filter the results.
But with Field-To-Field Filters you can directly use filter criteria and compare the two report fields to return records.
Simply, add a field filter, and change Value to Field in the filter dialog. In this example, a field-to-field filter (1) returns opportunities worth less than projected (2).
- Each report supports up to 4 field-to-field filters.
- Field-to-field filters only support these field types:
Atul Gupta is CloudVandana’s founder, an 8X Salesforce Certified, working with globally situated businesses in creating Custom Salesforce Solutions.
A strong, dynamic, and accomplished leader, as Director at Atul Gupta, guides all the aspects of CloudVandana Salesforce Implementation Team, Analytics, and Information Technology functions.
When I attempt to create a field-to-field greater than comparison between two number fields, I can’t seem to get the option to compare to another field. All I see is ‘greater than’. I checked and I have full permissions for reports. Is there something I’m missing?