>>>Maybe you've got a null value and are not catering for it? And maybe set nulldisplay is 0?
>>
>>In the expression I use NVL(sum_cost, 0). And besides, the stored procedure returns 0 for sum_cost. That's why I can not understand where this number is coming from.
>
>I am confused by your statement. You said the value for the inventory value shows and the report variable to show this figure is NVL(sum_cost, 0). But the one showing 0 is the qty on hand, so I understood that the qty on hand must use another variable or field and that is what I thought must have a NULL value in. Maybe you can try to explain the problem better, please?
As you see, it shows inventory value 1.91. It should show 0 since quantity is 0 and the sum_cost is 0 (this is what is used in the report for the inventory value column).
If it's not broken, fix it until it is.
My Blog