sum distinct from various tables

[#1]

Hello community

I wish to find distinct values off  various tables then sum those up.

Now because some of the entries returned from the various tables are the same (as in duplicates) when I count or sum  the results

I get a figure that is less the duplicates (mind you these resultant distinct are correct).

In effect what I finally get is a sum distinct of the distinct.

As opposed to just a summing of distincts.

Help

Prince

[#2]

Goo day Qlikview Wizard

I have since gone through your solution too.

Thank you very much, this too addresses that same issue.

You guys are Boss

Prince