This content has been marked as final.
Show 4 replies
-
1. Re: Sum a distinct numeric field.
Luke Bryant Oct 31, 2012 1:24 PM (in response to Kevin Baes)If you could post a sample dataset possible in excel it would be helpful.
-
2. Re: Sum a distinct numeric field.
Derk Busser Nov 1, 2012 2:45 AM (in response to Kevin Baes)Kevin,
Difficult to do this without changing the source data or being really careful...
2 options:
- In your source data, on a row level add the number of rowitems per claim, e.g. claim 11 has 5 rows, so add a column with nr_of_claimrows = 5. Then you can divide the total paid amount by the number of rows and then add them in your calculation
- Using AVG, MAX or MIN by showing the different claims as a dimension--> this is rather prone to error. See my attached screenprint
I hope this helps...
Best regards,
DErk
-
2012-11-01_1036.png 17.3 KB
-
3. Re: Sum a distinct numeric field.
Kevin Baes Nov 1, 2012 7:08 AM (in response to Derk Busser)Thanks Derk. I will give your solutions a try.
-
4. Re: Sum a distinct numeric field.
Alex Kerin Nov 1, 2012 8:00 AM (in response to Kevin Baes)You could also solve this through table calculations - see attached.
You have to be careful about partitioning. For example, the single value has Claims on the left, rev on the right, so that only the first row for each claim has an amount associated with it.
The sum has both on the right because we want to sum all single values. But you still have to set the partitioning for single value in the sum partitioning (via the drop down).
-
dupes.twbx.zip 8.1 KB
-