Hi ,

I need some help.

I want to add two results from PU_SUM ( child_table, parent_table.column [, filter_expression] ).

I wrote

ADD (PU_SUM ( child_table, parent_table.column [, filter_expression] ),PU_SUM ( child_table, parent_table.column [, filter_expression] ))

or

PU_SUM ( child_table, parent_table.column [, filter_expression] ) + PU_SUM ( child_table, parent_table.column [, filter_expression] )

But there is a rule: If no value in the parent table exists for the element in the child table (either because all values of the parent table column are filtered out, or because no corresponding value exists in the first place), NULL will be returned.

If the result of first of them = NULL, then the result from ADD is also NULL, although the 2nd result is <> NULL.

But I would like to have the sum of both. How should I do that?