Forum Discussion

CasieMasters's avatar
CasieMasters
Qrew Cadet
7 years ago

Filtering out a report by a field length

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.
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    7 years ago
    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.