I have a requirement to create a report that will filter and display all Address from Account that have a zip code of 6 digits.
Can someone help me to achieve this?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityI have a requirement to create a report that will filter and display all Address from Account that have a zip code of 6 digits.
Can someone help me to achieve this?
You can create a formula field on the object that is LEN(Zip code) that returns the number of characters. Then, in your report, you can add a filter for that number equal to 6.