Skip to Content
0
Jun 17, 2020 at 04:28 PM

Summary of SQL formula not displaying 0

24 Views

I have a SQL formula:


(select
case when ORDER_RAD_REPEATS.REPEAT_RSN_C = 5 then COALESCE(ORDER_RAD_REPEATS.NUMBER_REPEATS, 0) end COALESCENUMREPEATS05
from ORDER_RAD_REPEATS
where x_ahc_rad_procs.order_proc_id = order_rad_repeats.order_proc_id
)

When I insert a Summary-Sum if the sum is 0, it does not display, I checked the customization fields and Suppress If Zero is UNCHECKED.

Thank you.