Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Column Rendering as "Plain Text" - is Numeric - how to re-define

Nita TeetersFeb 21 2024 — edited Feb 21 2024

Hello!

I have created an interactive report pulling the maximum score using **MAX(a.score) as "ALG1" ** from a table with numeric values. The values are numbers, however, the report has designated the column as “Plain Text” therefore I cannot filter to a value range (e.g., < 684). The options when trying to filter the score are text-related:

Is there a means of specifying that the variable should be numeric? The drop down for Type does not seem to have that option:

Thanks for any help!

Comments
Post Details
Added on Feb 21 2024
4 comments
61 views