I have a problem with a report that uses a left outer join. What we are trying to do is set a formula field and shared number variable to "0" if there is no record in the right table, and use the value in the right table if one exists.
What seems to be happening is that the formula works in cases where there is a value, but doesn't appear at all if there is no associated record in the right table.
Does anyone have any suggestions?
Thanks again for your time.
-Dan