Discussions

Expand all | Collapse all

Filtering out a report by a field length

  • 1.  Filtering out a report by a field length

    Posted 10-12-2018 21:57
    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.


  • 2.  RE: Filtering out a report by a field length

    Posted 10-12-2018 22:00
    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.