Skip to Content
0
Former Member
May 19, 2010 at 06:03 PM

Creating a Sum based on Distinct records

36 Views

Does anyone know how to create a sum only distinct records from a field?

Example:

100

100

200

100

200

100

100

200

200

100

200

100

Group level Sum goes here. How can I sum only the 100 and 200 together once?

Thanks!!!