Skip to Content
0
Former Member
Oct 31, 2005 at 07:05 PM

How to only sum values of unique records??

49 Views

Hi gurus,

I have a problem in a query

I have a lot of records that are the same and I don’t want to sum the value of them more than once. How can this be done??

The following table should illustrate my problem:

What the OLAP-engine does:

Type--


Inspection Lot-Sample size

Contents 40000000000 ----3

Contents 40000000004 ----5

Contents 40000000009 ----5

Contents 40000000010 ----1

-


<b> Result 14</b>

Appearance 40000000000 ---3

Appearance 40000000004 ---5

Appearance 40000000009 ---5

Appearance 40000000050 ---5

-


<b>Result 18</b>

-


Overall Result <b> <u>32</u></b>

I want the Overall result to be 19. (only summing up unique records).

Any help will be greatly appreciated.

Thanks,

Br

Anders

<b></b><b></b>