Oracle SQL Saying NULL instead of 0 (ZERO)

Question

I have a query where it is subtracting from two columns and then dividing to generate a percentage complete. If the area hasn't been started it propduces NULL I would like it to instead show 00 or 0.

Here is my Query:

substr(count(process_locations.count_attempt_id)/count(processes.process_id),2,2) as "Percentage Complete"

I have try NVL, and COALESE, but am unsure where to place them I have tried a few combinations, but i Receive errors.

I have also tried a CASE WHEN ELSE END, but it still said null.

Answer 1

You may try like this:-

NVL(substr(count(process_locations.count_attempt_id)/count(processes.process_id),2,2),0) as "Percentage Complete"