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. This means, opportunities are 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).
Note:
- Each report supports up to 4 field-to-field filters.
- Field-to-field filters only support these field types:
- Numeric
- Date
- Datetime
Atul Gupta is CloudVandana’s founder and an 8X Salesforce Certified Professional who works with globally situated businesses to create Custom Salesforce Solutions.
Atul Gupta, a dynamic leader, directs CloudVandana’s Implementation Team, Analytics, and IT functions, ensuring seamless operations and innovative solutions.
Request a Free Consultation
YOU MIGHT ALSO LIKE
Salesforce Agentforce: From Reactive to Proactive Solutions
The Power of ServiceNow ITSM
What is a Front-End Developer? A Complete Guide to Their Role, Skills, and Impact
10 Advantages of Staff Augmentation for Software Development Projects
Hire Certified Salesforce Developers: Drive Success with Expert Talent
Hi Ankur,
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?