Skip to Content
0
Former Member
Nov 15, 2012 at 06:51 PM

Exception aggregation in a document/position scenario

17 Views

Hi, maybe someone can help me figure out how to aggregate this

I have two ratios:

A B

Doc A Pos 1 1000 123

Doc A Pos 2 1000 233

Doc A Pos 3 1000 344

Doc B Pos 1 2000 123

Doc B Pos 2 2000 233

Ratio A is fixed along all the position of a document, while ratio B is standard.

If I remove position, at doc level I should aggregate normally B, while ratio A should show the fix value. However for upper levels, if I remove document, ratio A should aggregate normally, summing one occasion of the fixed value A for each document.

Any ideas?

Thanks