DevOps, CI/CD and Automation

I've developed a report whose output looks like this:
----------------------------------------------------------------------------------------------------------------
Subinventory | Part Code |Part Description |Ordered Qty | Received Qty
-----------------------------------------------------------------------------------------------------------------
Mentone St | BATT | non serialised item | |
Mentone St | SONY | spare parts MIN MAX | 30| 0
---------------------------------------------------------------------------------------------------------------

In the above report

subinventory, Part Code, Part description are in one repeating frame and Ordered and received qty are in other repeating frame.

for a perticular part code there may not be ordered or received quantities. Means the seond query fetches no rows for the perticulat partcode. In that case report is showing null(blank) but I want to print ZERO there.

If I use NVL in the query it'll effect only when the query fetches some rows.

I've tried with formula columns. for example in the formula column

IF :ordered_qty IS NULL THEN
v_ordered_qty :=0;
ELSE
v_ordered_qty := :ordered_qty;
END IF;
return(v_ordered_qty);

I've assigned this formula column as source to the Ordered Qty Filed. Then also its not working.

Any help in this regards is highly apprecialted

regards,
Vij