Hello,
I have a decimal field in the database. I need to display the filed based on a condition as below:
IF (FUND='A') then (VALUE1) else ('NA'). It works if I keep NULL instead of 'NA'.
I used to_char( and cast function as below. But they are giving Oracle invalid number error. How should I move head?
Using cast: IF (FUND='A') then (cast ((VALUE1),varchar(20))) else ('NA')
Using char(: IF (FUND='A') then (to_char(VALUE1)) else ('NA')
Thanks,
Are you doing anything with that field after you put NA into it, for example have you got a total at the bottom of your report?
No. Just showing detail level data only in the report. No summary totals are needed.
I had to change the 'Total' function of that column to minimum. It is working as per my needs. Thank you BigChris for the inputs.