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?


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.

  • 1
    Which is kind of unfortunate, because formulas can cause a full table scan-- this can definitely impact performance of the report. – sfdcfox Oct 5 '16 at 23:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.