Skip to Content
0
Former Member
Dec 15, 2015 at 10:45 AM

Distinct Sum

415 Views

Hello,

I am facing a problem regarding column calculation in WEBI 4.

Below is an example :



These 2 lines obviously aren't duplicates because of the date difference, but based solely on the "case id", they are referencing the same operation from my work point of view.

Is there a way to make a total sum for each unique "case id" ? In this case i'll end up with 250000 instead of 500000.

Thank you !

Attachments

Capture.JPG (21.4 kB)