OTBI Filter for Numeric using MAX

Summary:

Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers.

Content (required):

Data on DFF column is Varchar and goal is to get the max value while and ignoring the alphanumeric value records.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

thinking of using regexp_like in filter condition to but not sure if correct syntax or approach.

EVALUATE('REGEXP_LIKE("Job"."PER_JOBS_DFF_DB", ''^[[:digit:]]+$'')')