Filtering out a report by a field length

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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.
Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
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.