using

case when trunc({today})-{duedate} < 0 then {amountremaining} end

in a formula currency field (customer search), in the event the result is 0 is it possible to display an actual numeric “0.00” instead of a blank field?

currency is displayed as 0.00 when the value is 0

as in

case when trunc({today})-{duedate} between 1 and 30 then NVL({amountremaining},0) end

? it’s a sumamry type SUM field too btw, if that makes a difference

makes no difference, use NVL to make your expression return a different value if amount remaining is null

how odd, i still see a blank result

id guess you have rows where the difference between today and due date isnt between 1 and 30

that did the trick. thanks!