I tried the other way around and it works but then the end user will have to convert the character field to a numeric field before they can do mathematical operations on the values.

I have 2 sqls above that work beautifully if run individually but when I try to do a union of the 2 queries, I run into issues. I suspect that my problem is that the field peev.screen_entry_value is data type (VARCHAR2) and det.value is numeric. I tried different ways to convert the VARCHAR2 field into numeric but I am not…