Skip to main content
Question

Filtering out a report by a field length

  • October 13, 2018
  • 0 replies
  • 20 views
I need to filter out a report to have it only list the records where the field length is less than or equal to a number (6).  How do I create a formula field that counts the field length of another field?  If I can do that, then I can just add that filter into my report.  Just not sure of the syntax for the formula as the Length function seems to want text and in this case my field in reference is numeric.
      This topic has been closed for replies.

      • SuryaExpert
      • Registered
      • October 13, 2018
      You can do this. Length(ToText([<My Numeric Field>])=6. To use it in your report filter, you could either create this field on the table or just in the report as a calculated field. Hope that helps.
      Terms & ConditionsAccessibility statement